Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 13 Aug 2010 @ 13:29:56 GMT


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


Subj:   Re: Regarding usage of index
 
From:   Shahzad, Omer

Hello Prasad,

The idea is simple you have defined your PI on C1 and C2 when you are using C1 or C2 in condition the optimizer cannot see the PI because PI is based on two columns not only one. Optimizer thinks that PI is C1+C2 for example studentLastname+StudentID. For optimizer C1 or C2 is simply a column not studentLastname+PI

But if you don't want to change your PI (from C1+C2) you can define a Secondary index on that column which you are using in condition so that response time will be better.


Thanks & Regards

Omer Shahzad



     
  <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