Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 07 Jan 2005 @ 10:50:23 GMT


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


Subj:   Stats on Volatile table -- Possible??
 
From:   Venkata Makkena

Can We collect stats on volatile tables?

I am wondering how can we collect stats without an entry in DD, But as per the book titled "teradata SQL UNLEASH THE POWER" by LARKINS and COFFING, We can collect stats on volatile tables using the following Statement.

     create volatile table T1;

     Collect temporary statistics on T1 column(c1).

I tried, but I got an error that we can not run stats on volatile table.

Appreciate your ideas.


Thanks

Ramana



     
  <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