Archives of the TeradataForum

Message Posted: Tue, 17 Aug 2010 @ 16:25:46 GMT

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

Hello,

A "small table-large table" join is a completely appropriate place for a product join. If the small table is really small, then distributing it to all the AMP's means that each AMP can do the join without talking to any other AMP's. Now, correct statistics will allow your database to decide if a small table really is small. If there's an increase in size, causing it not to be a small table, the join type should change if the optimizer is provided updated statistics. So yes, a product join is not always bad.

iv

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