Show TOC

EQUAL CONDITION FOR INDEXLocate 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.