If search conditions are specified for key columns, the search is limited to the corresponding part of the table, that is, the search strategy is determined as specified in the table.
Search Condition |
Search Strategy |
Equality condition for every key column |
The system accesses the appropriate table row(s) directly. |
IN condition for one key column and an equality condition for all other key columns |
The system accesses the appropriate table row(s) directly. |
Any other search condition for the key columns |
Upper and lower limits for the valid key range are created for the key columns. All search strategies, including strategies using inversions, use the knowledge of this valid search range. |