Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 04 Dec 2007 @ 15:37:52 GMT


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


Subj:   Join Index Question
 
From:   Kamin Shah

I have a query which is taking over 5 minutes. I have written 2 join indexes which I think would cover the query. When I look at the explain plan it just picks up one of the 2 join indices. When I drop one of them, it picks up the other one. I have collected the appropriate stats and have made sure the PI is appropriate.

The questions I have are the following:

1. Does Teradata use only 1 join index which it think will best cover the query or can it choose multiple join indices?

2. When I have both the indices present, it picks up the slower one for some reason. Any insight on this?


Any help is appreciated.



     
  <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