Archives of the TeradataForum

Message Posted: Tue, 19 Feb 2008 @ 17:59:04 GMT

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

To me this only means that the optimizer used the stats. The stats can always be outdated but even if they are brand new the optimizer can still get the counts wrong if it needs to apply conditions which are not easily computable from basic stats. I seldom pay attention to the counts. Only in cases when they are way out compares to my expectations I try to understand what is going on.

Victor

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