Tag Archives: Optimizer Mode

Optimizer Mode

Last updated on November 23rd, 2015 at 03:34 pmSet in the Init.Ora Can be changed via ALTER SESSION CHOOSE, FIRST_ROWS, ALL_ROWS = cost based optimization RULE = rule based optimization Optimizer_Mode = Rule Original optimizer developed by prior to 7 Applications prior to 11i must run as RULE to be supported Documentation has warned of its removal uses strict rules for determining the execution path … Continue reading Optimizer Mode »