Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 29 Oct 2010 @ 14:03:19 GMT


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


Subj:   Re: Global Temporary table and collect stats
 
From:   John_Wight

There are restrictions on stats on GT tables. Here are some rules from some info I have:

Rules for using InsertStats on Global Temporary tables:

You can collect most statistics on a global temporary table with the following exceptions:

You cannot collect statistics on multiple columns.

You cannot collect statistics on a named index by index name for a materialized global temporary table.

You cannot collect PARTITION statistics.

Table must be materialized in order to run collect statistics on it (at table level.

So, following the above rules, apply stats on the 'un-materialized' table. Then, after the table is materialized, then you can execute the COLLECT STATS ON ; This information was good as of 2.6.2 - not sure if any of these were lifted on TD12 or greater - but, you could chekc the manuals!

The manuals are pretty clear on this;-)


JK



     
  <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