SQL Optimizer

The task of query optimizer is to determine the most efficient means for executing queries.

The query optimizer consists of the following sub-modules:

• Query Resolver
• Query Optimizer
• Query Planner
• Query Executor

The Optimizer Trace

Additional articles about the query optimizer:

• The Optimizer Trace
• Aggregate checks of ONLY_FULL_GROUP_BY