EXPLAIN - Subquery Scan

Description:

A Subquery Scan is for scanning the output of a sub-query in the range table. We often need an extra plan node above the sub-query’s plan to perform expression evaluations (which we can’t push into the sub-query without risking changing its semantics).

Important Fields:

• Filter
• Rows Removed by Filter