Subquery optimization

Subqueries use the following optimizations to improve performance:

The following sections explain these strategies.

See “showplan messages for subqueries” for an explanation of the showplan messages for subquery processing.