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

 

SUBQ CONDITION FOR INDEX is one of the database system.

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

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

  • The search condition contains one equality condition for all columns of an index.

The values for the inversion list or index columns come from a subquery.