EXPLAIN Statement

You can use the EXPLAIN statement to find out which search strategy the SQL optimizer selected for executing an SQL statement.

• SQL Optimizer, Displaying the Search Strategies Used by SQL Statements (EXPLAIN)

• SQL Reference Manual, EXPLAIN Statement (explain_statement)

• Database Studio, Displaying the Search Strategies Used by SQL Statements (EXPLAIN)

• Database Administration in CCMS, Command Monitor