Archives of the TeradataForum

Message Posted: Wed, 15 Jan 2003 @ 11:22:58 GMT

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

Harold,

Jose is correct.

Given that the join is NOT a PI to PI join then one/both of the tables need to be moved. In this case the optimiser is guessing that the Daily_Sales_Item table is large ("low confidence" typically means no stats) and it knows there are only 16K rows on Store. Rather than having to move or sort the large table in order to do a row-hash match, the large table is simply left in situ and the small table is dup'd on all amps and product joined. This is the plan you're seeing.

Cheers,

Dave

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