Explain 'Cost-Based Optimization' (CBO).

Explain 'Cost-Based Optimization' (CBO).

Approach: Describe query planning based on data statistics.

A method used by database query optimizers to find the most efficient execution plan for a query by calculating the 'cost' (CPU, I/O) of various paths based on table statistics.

Follow-up: Why do statistics need to be updated?

Key concepts: execution plan, statistics, best path.