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 ...

Get OCP Upgrade to Oracle Database 12c Exam Guide (Exam 1Z0-060), 2nd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.