Background documentationCATALOG KEY ACCESS Locate 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.