If search conditions are specified for key columns, then two cases can be distinguished:
- If an EQUAL or IN condition refers to the only key column, then the corresponding row(s) is (are) directly accessed.
- For all the other conditions specified on key columns, an upper and a lower limit are determined for the valid range of keys. All strategies, even those implemented with indexes, utilize this knowledge of the permitted range of keys.