Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 16 Dec 2003 @ 11:36:41 GMT


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


Subj:   Re: How much statistics to collect
 
From:   Dieter Noeth

David Clough wrote:

  This news concerns me somewhat, as one school of thought in our shop (please excuse the mixed metaphor) is that for low cardinality columns - where there are no Statistics at all on the column - Dynamic Random Amp Sampling ('DRAS') would produce an adequate Explain Plan.  


  Having tried an example, however, I can certainly confirm that Martin is indeed correct and found that Teradata would appear to take the cardinality of the Primary Index as its basis for arriving at the (no confidence) Explain estimate.  


  My example was based on pretty small tables, but I assume the principle would extend to larger ones.  


  Can anyone shed any light on the situations in which 'DRAS' would come into play (ooh, another mixed metaphor) ?  



It's only done with indexes, primary or secondary, as it calculates the number of rows by reading one cylinder index without accessing any datablocks. If you try a query on a col without statstics using "where col = xyz", you'll see a "estimated with no confidence" without index and "estimated with low confidence" with index.

The same for "sel col from tab group by col", but not for "sel distinct col"?


Dieter



     
  <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: 23 Jun 2019