List different types of indexes in Teradata?

Primary Indexes: Unique Primary Index(UPI) , Non Unique Primary Index( NUPI)

Secondary Index : Unique Secondary Index(USI), Non Unique secondary Index(NUSI)

Join Index


1. Each table may only have one Primary Index, but every table must have a Primary Index defined.
2. PRIMARY INDEXES may be defined on one column, or on a set of columns viewed as a composite unit. Up to 16 columns may be defined as a Primary Index.
3. A table can have 32 secondary indexes.
4.Once created, the primary index cannot be dropped or modified, the index must be changed by recreating the table
5. Unlike the primary index, a secondary index can be added or dropped without recreating the table.