- Primary index In general, all 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