Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 26 Mar 2003 @ 17:16:54 GMT


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


Subj:   Re: Volatile Table
 
From:   Claybourne L. Barrineau

Srini,

Instead of volatile tables (which don't allow for the collect of stats nor SIs), try using global temporary tables. With Global Temps, you can collect stats and create indexes like a permanent table. In addition, like volatile tables, they will dissappear at the end of your session.


Hope this helps,

Clay



     
  <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