Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 05 Feb 2004 @ 21:05:18 GMT

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

Subj:   Re: Query Performance
From:   Christie, Jon

It's entirely up to you. It doesn't look like a good plan to me. Nested joins only make sense then the number of rows that result are less than the number of blocks in the table they came from. Is the secondary index the nested join uses lumpy (very high rows per value for some values) by any chance?

  <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: 27 Dec 2016