Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 25 Apr 2012 @ 12:51:00 GMT


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


Subj:   Re: Mutli-Column Stats
 
From:   Gregg, William

Hi -- I was just at the Midwest User Group Mtg and Teradata staff did not have much enthusiasm for multi-column stats.

I concur with everyone that has said to be certain that any multi-column stats improve a plan before applying them.

Applying all multi-column stats recommended per the help stats diagnostic leads to unnecessary stats collection and per Teradata Staff often confuses the Optimizer.


Good Luck,

Bill Gregg



     
  <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