Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 05 Mar 2009 @ 22:06:54 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: Data access using views
 
From:   madhumitha.das

We have few tables around 500GB. So when tables are big, we do have spool overhead, isn't it?

In our rapidly growing data warehouse, almost 90% of the operations (Mloads, FastExports, Complex DML queries, Report generation etc) are all setup against databases with base tables and so far no issues. Will there be any advantage(s) if we spend time migrating these operations against views (pointing to base tables)?

For example,

     REPLACE VIEW REPORTSV.ZIP_CODES AS
     LOCKING ROW FOR ACCESS SELECT * FROM REPORTS.ZIP_CODES;

Madhu Das



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023