Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 16 Jun 2010 @ 14:40:36 GMT


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


Subj:   UNION ALL- Index is not Used
 
From:   Ramachandran, Janardhan

Hi All,

I have a view which has the UNION ALL between three big tables. When the view is used in the queries the secondary indexes of the tables are not been used.

Any body has came across such a scenario earlier, If so please give share your valuable Inputs.

Thanks for your help,


Thanks & regards

Janardhan R



     
  <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