List of All Search Strategies
The following lists all the search strategies recognized by SQL Optimizer. The names match the return codes of the EXPLAIN statement. You can use this statement to query the search strategy chosen by the SQL Optimizer for a particular SQL statement.
CATALOG SCAN USING USER EQUAL CONDITION
DIFFERENT STRATEGIES FOR OR-TERMS
JOIN VIA MULTIPLE INDEXED COLUMNS
JOIN VIA RANGE OF MULTIPLE INDEXED COL.
JOIN VIA RANGE OF MULTIPLE KEY COLUMNS
NO STRATEGY NOW (ONLY AT EXECUTION TIME)
See also: