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

 

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

When Can the System Use This Strategy?

The database system can use this strategy for search conditions that contain an equality condition for all columns of an index.

How Does the System Access the Data?

The database system directly accesses the table rows using the inversion list.