Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 06 Mar 2002 @ 11:25:10 GMT


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


Subj:   What information does 'collect statistics' store?
 
From:   Andrew Doorey

When statistics are collected on a column does it store the actual number of rows for each individual column value, or does it store an average number of rows per value?

eg. A table has a date column which we have collected statistics on and we then load a new week's data to the table. If we run a query on the table against the new week's data do the statistics say that there will be no rows in the table and create an execution plan accordingly, or will it say that there is an average number of rows and create a different execution plan?


Thanks,

Andy.



     
  <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