1.

What is PPI (Partitioned Primary Index)?

Answer»

As its name suggests, Partitioned Primary Indexes (PPI) are one of Teradata's powerful features that allow users to access a specific portion of a table instead of the WHOLE table. Essentially, PPI is an INDEXING mechanism that will help improve query performance. When used for data distribution, PPI works the same way as Primary Index, and partitions are created based on range or case as specified in the table. In partitioned primary indexes (PPIs), rows are sorted according to the partition number. 

  • By using PPI, you can avoid a full table SCAN and only access required partitions. 
  • Using PPI prevents the use of secondary indexes, as well as additional I/O MAINTENANCE. 
  • It enables quick access to a subset of a large table. 
  • PPI enables removing old data and adding new data to a table with ease. 


Discussion

No Comment Found

Related InterviewSolutions