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: 28 Jun 2020