Archives of the TeradataForum

Message Posted: Tue, 10 Aug 2004 @ 23:20:35 GMT

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

Did you collect statistics on the columns appearing in the WHERE clause? If you did, I would at least expected you to have seen that the confidence in the estimates was higher after collecting statistics and I would expect the estimates to change as well.

Jon

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