Adaptive Query Plans

optimizer_adaptive_plan

Adaptive query plans are enabled by default.

Adaptive plans are enabled when the following initialization parameters are set:

• OPTIMIZER_ADAPTIVE_PLANS is TRUE (default)

• OPTIMIZER_FEATURES_ENABLE is 12.1.0.1 or later

• OPTIMIZER_ADAPTIVE_REPORTING_ONLY is FALSE (default)

Adaptive plans control the following optimizations:

• Nested loops and hash join selection

• Star transformation bitmap pruning

• Adaptive parallel distribution method