What is the goal of Optimizer?
The goal to Optimizer is to find the most efficient way to execute the SQL statements.