Background documentationRANGE CONDITION FOR KEY Locate this document in the navigation structure

 

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.