Show TOC

CATALOG KEY ACCESSLocate this document in the navigation structure


CATALOG KEY ACCESS 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 which contain equality conditions on database object keys.

How Does the System Access the Data?

The database system uses the key columns in the database catalog to access the data.