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.