What is adaptive query optimization?

Adaptive query optimization dynamically adjusts execution plans based on runtime statistics.

Traditional optimizers choose a fixed execution plan before execution starts. Adaptive query optimization improves this by adjusting join strategies, memory allocation, and parallelism during execution. This is useful when initial cardinality estimates are wrong. Systems like Oracle and modern distributed engines (Spark SQL, SQL Server Adaptive Joins) implement this to avoid catastrophic plan failures.