Tag Archive: PPI

Mar 21

Partition Primary Index – Advantage and Disadvantage

Advantage of Partition Primary Index – Partitioned Primary Index is one of the unique features of Teradata, which is used for distribution of rows based on different partitions so that they can be retrieved much faster than any other conventional approach. Maximum partitions allowed by Teradata – 65,535 It also reduces the overhead of scanning the complete …

Continue reading »

Feb 25

Partition Primary Index – Basics

Partitioned primary index or PPI is used for physically splitting the table into a series of subtables. With the proper use of Partition primary Index we can save queries from time consuming full table scan. Instead of scanning full table, only one particular partition is accessed. Follow the example below to get the insight of PPI – …

Continue reading »