Background documentationEQUAL CONDITION FOR KEY Locate this document in the navigation structure

 

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

When Can the System Use This Strategy?

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

  • The table has only one key column.

  • The search condition contains an equality condition for this key column.

How Does the System Access the Data?

The database system directly accesses the table rows.