Column-partitioned tables and join indexes can have one of these indexing methods:
- Primary AMP index (PA)
- Primary index (PI)
- No primary index (NoPI)
NoPI is covered in the following topic NoPI Tables, Column-Partitioned NoPI Tables, and Column-Partitioned NoPI Join Indexes.