Archives of the TeradataForum

Message Posted: Wed, 11 Aug 2004 @ 13:53:52 GMT

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

Hi Jon,

We are joining based on the subset of the primary index of the large table thats where the problem comes in. But I created a secondary index on the columns that I am joining and also collected statistics on that index columns. Even then, it is doing redistribution of Large table and a product join with the smaller table. I collected statistics on the column of the small table too.

Thanks,

Prasanna.

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