About Choosing a Primary Indexing Method for a Column-Partitioned Table or Join Index - Teradata Database

About Choosing a Primary Indexing Method for a Column-Partitioned Table or Join Index

Column-partitioned tables and join indexes can have one of these primary indexing methods:

No primary index (NoPI)

Primary index (PI)

Primary AMP index (PA)

NoPI is covered in the following topic “NoPI Tables, Column‑Partitioned NoPI Tables, and Column-Partitioned NoPI Join Indexes” on page 230.