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