Show TOC

CATALOG SCAN USING USER EQUAL CONDITIONLocate this document in the navigation structure

Use

CATALOG SCAN USING USER EQUAL CONDITION is a search strategy of the SQL optimizer.

When Can the System Use This Strategy?

The system can choose this strategy when the schema name was specified exactly.

Example

EXPLAIN

SELECT * FROM TABLES

  WHERE schemaname = 'HOTEL'

How Does the System Access the Data?

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

More Information