Archives of the TeradataForum
Message Posted: Wed, 15 Jan 2003 @ 11:22:58 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|