Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 22 Jun 2005 @ 12:36:10 GMT

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

Subj:   Re: Sort before Join
From:   David Wellman

Typically so that it can do a row-hash match scan. This requires that the two objects to be jined are in the same sorted order - and Teradata's 'order' is row hash.

Look at the step where the sort is happening and find the number of the OUTPUT spool file. Now find the next place where that spool file is used, it will typically be a row-hash match scan.



  <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