RANGE CONDITION FOR KEY is a search strategy of the database system.
With this search strategy, the database system searches the specified range of the table sequentially. For this the database system forms a start and stop key to restrict the range.
The database system uses this search strategy if one of the following conditions is met:
For the first k columns of the primary
key, equality conditions were specified (1 <= k <
n
, n is the number of key
columns). All other key columns were specified either not at all or with a
range condition.
The first key column was specified with a range condition.
The values of an IN condition are very close together.