Optimizer Mode
What is Optimizer Mode Optimizer is the mind of the Oracle engine and it decides the execution plan of the sql queries to be executed. Optimizer has different mode and Optimizer Mode in the parameter which is used to specify the different modes Set in the Init.Ora Can be changed via ALTER SESSION CHOOSE, FIRST_ROWS, …
