Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 17 Apr 2003 @ 20:49:06 GMT


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


Subj:   Create testing plan for big tables join
 
From:   Tan, Yvonne

Greetings!

We are building a view that has 11 history tables join. Each history table contains 19 million records. Our test environment only has 700,000 records for us to test the view performance. Is there a way I can predict the production performance (i.e., DBMS time, Fetch time, and spool space used) by running explain based on 700,000 test records? Please advise.


Thanks,

Yvonne



     
  <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: 27 Dec 2016