Archives of the TeradataForum

Message Posted: Mon, 26 Sep 2005 @ 17:21:16 GMT

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

Madhukar,

Can you please include the table ddl and help stats?

My guess is some other stat is missing or out of data. Try collecting stats on the Primary index on the large table.

Thanks,

Bob Diehl

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