Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 03 Aug 2011 @ 14:20:56 GMT

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

Subj:   Re: Difference between collect stats on a column vs. a table
From:   narayan.murthy

1.Stats is basically a facility available to DB optimizer to understand the demography/distribution of the data to come up with better plans.

2.It does consume space and time when ever collected.

When you have tomany columns and you obviously dont want to miss out on any column you could collect stats on the table(which covers all cols). But then when you know which columns are most frequently used in query conditions, then you can collect stats on the specific columns alone.


  <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