EXPLAIN Statement for Complicated SELECT Statements 

The SQL Optimizer breaks down complicated SELECT statements into multiple internal SELECT steps that create temporary results.

For SELECT statements of this type, the EXPLAIN statement provides multiple search strategies. INTERNAL TEMPORARY RESULT is specified as the table name. Searches across internal temporary results of this type are only ever sequential.