Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 11 Aug 2005 @ 15:59:34 GMT


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


Subj:   Re: Primary Index vs Single Condition
 
From:   Anomy Anom

<-- Anonymously Posted: Thursday, August 11, 2005 11:52 -->

Since you are retrieving a significant percentage of the table rows, it's not surprising that a single table residual condition is faster.

Just for fun, you might also try an inner join between the two tables rather than the IN clause you are apparently using (based on the explain saying it's an "inclusion merge join").



     
  <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