EXPLAIN - Subquery Scan


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

Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →