15.00 - Secondary Indexes Can Shorten Search Time - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Teradata Database
Release Number
Content Type
Programming Reference
Publication ID
English (United States)

Secondary Indexes Can Shorten Search Time

Secondary index values can shorten table search time for multirow selection. Multirow selection is often referred to as set selection. Each row in a secondary index subtable is made up of the index value and one or more row IDs that point to the data row set containing that value. Therefore, when secondary index values are used as conditional expressions in SQL statements, only the row set that contains the specified value is accessed.