Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 22 Aug 2006 @ 09:35:28 GMT


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


Subj:   Join Index Hint Tool
 
From:   Anomy Anom

<-- Anonymously Posted: Monday, August 21, 2006 20:00 -->

We are tantalized by the potential of Join Indexes, but find that they don't get picked up when we strongly believe they should. Someday I'd love to see the Explain embellished to say why it ignored the Join Indexes that exist. Maybe we could turn it on as an optional parameter:

     Explain JI_Detail=YES mySQL;

The embellished Explain would tell me why it didn't use the JI. As it stands, we're playing 20 questions with Explain to guess what it will take to get it to work and usually end up giving up after 200 questions.



     
  <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