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

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
Language
English (United States)

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.