Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 30 Mar 2005 @ 17:49:59 GMT

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

Subj:   Re: Statistics Help
From:   Fadel, Michelle

Tad Warnick is here onsite and he wants to say that this diagnostic is not supported and collecting stats can be very expensive. The hierarchy to be followed is single column high confidence, followed by single column low confidence (single column stats are not that expensive). Look at multi column high and low, but just because stats are being evaluated, it doesn't mean that collecting them will change the plan.

In my experience, collecting multi column stats recommended by this diagnostic ran up my collect stats hours but didn't change the queries. We ultimately dropped those multi column stats.

Michelle Fadel

  <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