A Mental Model You Can Use

Here’s a simplified way to think about SQL execution, especially if you come from an algorithm or systems background:

• SQL is a request.
• The optimizer is a planner.
• The execution plan is a strategy.
• Execution is a parallel, resource-aware run of that strategy.

When performance suffers, one or more of these steps failed to line up with reality.