Archives of the TeradataForum

Message Posted: Wed, 22 Oct 2003 @ 15:37:20 GMT

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

Rick,

I believe the Table1 is redistributing on all amps and then performing the JOIN operations . Use derived tables to duplicate the small table on all amps . Hope this might fix your problem .

It will be great if you can post the explains

Srini

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