- Primary index
In general, all Teradata Database tables require a primary index because the system distributes tables on their primary indexes. Primary indexes can be:
- Unique or nonunique.
- Partitioned or nonpartitioned.
- Secondary index
Secondary indexes can be unique or nonunique.
- Join index (JI)
- Hash index