Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Strange Product Join?
From:   David Wellman


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.



  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020