EXPLAIN Statement 
You can use the EXPLAIN statement to find out which search strategy the SQL optimizer selected for an SQL statement.
More Information
SQL Optimizer, Explain Statement
SQL Reference Manual, EXPLAIN Statement (explain_statement)
Database Studio, Analyzing an SQL Statement (EXPLAIN)
Database Administration in CCMS, Command Monitor