All Forums Teradata Applications
pavanvarma4858 1 post Joined 05/14
15 May 2014
PPI

What is a PPI and how does it help increase the performance while retriving data

Raja_KT 1246 posts Joined 07/09
16 May 2014

I suggest you go through Teradata materials.

Row-partitioned primary indexes are defined for tables that are frequent targets of range or

row-partition-based queries and also case basis. 

 

The performance gain depends on the number of partitions, design of partitions, and the specific query being measured. I/O contention for a query can be less than  the one it takes to run the same query against the table with a non-partitioned primary index (NPPI)

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.