Background documentationCATALOG SCAN USING USER EQUAL CONDITION Locate this document in the navigation structure

 

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 Example

EXPLAIN

SELECT * FROM TABLES

  WHERE schemaname = 'HOTEL'

End of the example.
How Does the System Access the Data?

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