Adaptive execution plan An execution plan that changes after optimization when run-time conditions indicate that the current optimizer statistics aren’t accurate. Adaptive plans contain multiple built-in plan options and choose one of them during the first execution of a statement, based on the observations made by the optimizer during the execution up to this point in time.
Adaptive optimizer A feature that lets the optimizer adapt query plans based on run-time statistics.
Adaptive query optimization Capabilities that let the adaptive optimizer adjust execution plans at run time and discover additional information that can help attain more ...