Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 25 Feb 2004 @ 18:41:15 GMT


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


Subj:   CREATE TABLE...AS and when SIs are created.
 
From:   Greg Bourgoin

I'm wondering if anyone can tell me when secondary indexes are materialized on the new table when using the CREATE TABLE...AS syntax. Are the indexes created with the table, then the data is loaded (bad)? Or, is the data loaded and THEN the indexes are created (good)? For smaller tables this may not be an issue but I'm getting ready to create/load a 70+million row table with 3 SIs. It would make the difference of 15-20 minutes versus many hours.

Though just doing the old fashioned create/load/create indexes would have been faster than actually typing this message, I still would like the benefit of knowing for myself (and others) what the answer is for future reference.


Have a good one,

Greg



     
  <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