Archives of the TeradataForum

Message Posted: Wed, 28 Sep 2005 @ 08:38:46 GMT

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

Drop all the statistics (including index stats) on small table and check the explain. If it works as you expected then you can use this as a temporary workaround. If stats are not collected then sometimes optimizer overestimates the rows in small table and goes for merge join by duplicating small table. Give a try possibly it may work. If it works please post the results in the forum.

All the best :-)

Thanks,

Praveen

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