The Teradata database provides various effective ways to improve the performance of a query. Indexes are the most important part of designing the database structure. Indexes not only provide an effective way to store data, but also help in determining effective access paths to data.
The commonly used indexes in Teradata are:
- Unique/non-unique primary index (UPI/NUPI)
- Unique/non-unique secondary index (USI/NUSI)
- Partitioned primary index (PPI)
- Join index (JI)
Think of an index as a two-field table: one contains a value, and the other a pointer to instances of that value in a data table:
Teradata is the relation database management ...
