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.