Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 18 Dec 2009 @ 22:03:15 GMT


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


Subj:   Problem using join index.
 
From:   Baig, Mohammad

Hi All,

I have created a join index on multiple tables. The query that I am trying to run uses a case statement of the sort

     Case when  = ' ' then  else 'Private'

Bothe column1 and column2 are present in the join index. However when I use this in the select the optimizer stops using join index.

I would also like to mention that column1 is present in multiple tables in my join index so I had to use alias name for that to get join index created.

Can someone suggest me why join index is not used by the optimizer. Or suggest me how to avoid using alias.


Thanks & Regards

Mohammad Usman Baig
ECRIS RETAIL MODELING TEAM



     
  <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