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

 

RANGE CONDITION FOR INDEX is a search strategy of the database system.

With this search strategy, the database system accesses the corresponding table rows directly using the inventory lists that lie within the specified range. The database system therefore searches only a part of the index and reads this part sequentially.

The database system can use this search strategy if one of the following conditions is met:

  • For the first k columns of an index, the search condition contains equality conditions (1 <= k < n, where n is the number of index columns).

  • The first index column was specified with a range condition.

  • The values of an IN condition are very close together.

More Information