Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 20 Oct 2004 @ 19:13:38 GMT


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


Subj:   Re: Explain and estimates on AGG functions
 
From:   Ballinger, Carrie

Ulrich,

As you have observed, the optimizer does not offer estimates for statistical functions. The optimizer provides estimates on steps where decisions are required when putting together the query plan. It used to be that with aggregates, no decisions needed to be made in terms of where in the query plan to do that step. But with the introduction of aggregate move-around in V2R5, estimates became necessary in order to decide if, or where, to move an aggregation step. So from V2R5 forward, you will see estimates on aggregation steps, because of that specific need.

I am not aware of any immediate plan to provide estimates on stat functions.

Thanks, -Carrie



     
  <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