Output for flattened or materialized subqueries

Certain forms of subqueries can be processed more efficiently when:

When the optimizer chooses one of these strategies, the query is not processed as a subquery, so you will not see the subquery message delimiters. The following sections describe showplan output for flattened and materialized queries.