What Is Cost Based Optimizer?

1.	What Is Cost Based Optimizer?
Answer» Cost based optimizer is the optimizer COMPONENT of the Oracle, which is recommended and supported by Oracle. It determines query PLANS based on overall cost of usage of each resource to get the best possible plan with respect to the resource usage cost. It USES INTERNAL statistics to determine the best EXECUTION plan for the statement.

Answer»

Cost based optimizer is the optimizer COMPONENT of the Oracle, which is recommended and supported by Oracle.
It determines query PLANS based on overall cost of usage of each resource to get the best possible plan with respect to the resource usage cost.
It USES INTERNAL statistics to determine the best EXECUTION plan for the statement.

Discussion