SUBQ CONDITION FOR KEY is a search strategy of the database system.
With this search strategy, the database system performs a sequential search on part of the primary key for each results row of the subquery.
The database system uses this search strategy if the following conditions are met:
The table has only one primary key column.
The values for the key column come from a subquery.
or
The table has a primary key in several columns.
Equality conditions have been defined for all primary key columns that are located before the column with the subquery in the primary key.
On one column of the primary key, an IN condition is defined in the form of a subquery.