Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 20 Jan 2004 @ 07:08:03 GMT


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


Subj:   Re: Query Optimization with Inner Joins
 
From:   Hough, David A

  4) We execute the following steps in parallel.
       1) We do an all-AMPs RETRIEVE step from DATABASE_1.temp by
          way of an all-rows scan with a condition of ("(NOT
          (DATABASE_1.temp.SCHEDULE_ID IS NULL )) AND (NOT
          (DATABASE_1.temp.SESSION_ID IS NULL ))") into Spool 2
          (all_amps), which is redistributed by hash code to all AMPs.
          The size of Spool 2 is estimated with no confidence to be 114
          rows.  The estimated time for this step is 0.03 seconds.

This piece of the join plan is terrible. Try collecting stats on the PI for the small table and try to get the confidence above 'none'. Also consider altering the index and join columns to 'NOT NULL'.


/dave hough



     
  <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: 15 Jun 2023