Archives of the TeradataForum

Message Posted: Wed, 26 Apr 2006 @ 20:53:15 GMT

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

Hi Ketan,

Confidence high/low/no depends on stats collected on the joined columns and also on the intermediate spool tables joined columns. Estimated time are only rough estimates as the name indicates , once you run the query the actual run time varies because there might some other queries running on the system.

HTH

Naveen.

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