Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 12 Mar 2003 @ 15:45:09 GMT


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


Subj:   Re: Collect stats on PI
 
From:   David Wellman

Hi,

For all recent releases of Teradata, statistics are vital if the optimiser is going to get the correct join plan. If you don't have stats on the PI of a table then the optimiser will ignore any other stats that are collected on the table.

Stats help the optimiser with row count, data value skewing within a column etc. There are some access paths which typically will not be chosen unless there are stats on the relevant column/index (e.g. value-ordered nusi).

I think you'll find that the general consensus is that stats are no longer optional, they are a requirement.


Cheers,

Dave



     
  <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