8 facts due
A query can be executed in multiple ways. Explain the two-step process the query optimizer follows to arrive at a final execution plan, and why both steps are needed.