EXPLAIN Statement 

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

See also:

SQL Optimizer, Explain Statement

Database Administration in CCMS, Command Monitor

SQL Reference Manual, EXPLAIN Statement (explain_statement)