16.20 - Secondary Indexes Can Shorten Search Time - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
Content Type
Programming Reference
Publication ID
English (United States)
Last Update

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.