Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 12 Dec 2003 @ 23:58:08 GMT


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


Subj:   Re: Collect Stats on Single Column SI
 
From:   Christie, Jon

No.......

Statistics are always collected from the column(s) in the primary subtable. It is not possible (and not really useful) to collect stats on an index subtable.

The dividing point in statistics is whether they are collected on a single column or on multiple columns. Before 5.0.0, it was impossible to collect statistics on multiple columns unless there was a secondary index on that group of columns. As an implementation detail, single column stats (whether you used column or index syntax) are stored in DBC.TVFields while multiple column stats (whether you used column or index syntax) are stored in DBC.Indexes.



     
  <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: 23 Jun 2019