Explain 'Join Reordering'.

Explain 'Join Reordering'.

Approach: Describe the optimizer's choice of table execution sequence.

An optimization where the query engine changes the order in which tables are joined to minimize the size of intermediate results and improve overall performance.

Follow-up: How does the optimizer decide the order?

Key concepts: query planner, cardinality estimation.