Show TOC

CATALOG SCANLocate 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.