Archives of the TeradataForum

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

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

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>>