Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 12 May 2009 @ 09:33:18 GMT


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


Subj:   PPIs - Downside
 
From:   Goli, Srikanth

Hi - I am looking for any information available on cost of using PPIs. I have come across one article, that has some considerations, namely, a PPI that does not contain all PI columns may degrade performance ( may be because of the need to search in each partition for PI value). Are there any criteria to consider or should we just convert every table into PPI as long as the PPI columns are a superset of PI? I am specifically looking for any experience where PPI did not help performance or degrade performaqnce, so I can avoid those. Appreciate any feedback.


Thanks.



     
  <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