Archives of the TeradataForum
Message Posted: Tue, 12 May 2009 @ 09:33:18 GMT
| 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.