Background documentationCATALOG SCAN Locate this document in the navigation structure

 

CATALOG SCAN is a search strategy of the SQL optimizer.

When Can the System Use This Strategy?

The system can use this strategy if no equality condition has been defined for any key of the database object.

How Does the System Access the Data?

The database system sequentially scans the database catalog to access the data.