Show TOC

CATALOG ACCESS USING USERS TABLE LISTLocate this document in the navigation structure


CATALOG SCAN USING USERS TABLE LIST is a search strategy of the SQL optimizer.

When Can the System Use This Strategy?

In the database catalog, there is a list of visible tables for each database user. The system can choose this strategy if the query can be executed by traversing this list.

How Does the System Access the Data?

The system identifies the relevant tables using a key range scan.