what is a partion primary Index (PPI)?

Partion Primary Index (PPI) is a new concept introduced in V2R5 release of teradata.

users can choose PPI on table instead of UPI / NUPI.... PPI acts same as primary index to distribute rows but AMPs ordered data based on PPI column.... In case of Priamry Index AMPs order data using ROWID. In case of PPI AMPs order data using column and then ROW ID.

This is very useful for range queries.....

For example, Many times users use order date range to see orders from orders table

Ex : select * from orders where order_date between '01/01/2009' to '12/31/2009';

For these kind of queries if we can create PPI on order_date then performance will be
good