EQUAL CONDITION FOR KEY 

EQUAL CONDITION FOR KEY is a search strategy of the SQL Optimizer.

This search strategy can be used if both of the following conditions are fulfilled:

●     The table has only one key column.

●     An equality condition is specified for this key column in the search condition.

In this search strategy, the system accesses the appropriate table rows directly.

See also:

Equality Condition

Search Conditions for Key Columns

List of All Search Strategies