How does a cost based SQL optimizer work?

Cost Based Optimizer (CBO) uses the artificial intelligence to execute the Query. The Optimizer itself decides the execution plan based on the cost of query. The cost based method means the database must decide which query execution plan to choose.
For More Information Please Refer:

You May Also Like to Read: