Show TOC

EXPLAIN Statement for Complex SELECT StatementsLocate this document in the navigation structure


The SQL optimizer breaks down complex SELECT statements into multiple internal SELECT steps that create temporary results.

For SELECT statements of this type, the EXPLAIN statement provides multiple search strategies, and INTERNAL TEMPORARY RESULT is returned as the table name.

The database system can only search through intermediate results of this type sequentially.