Sep 20, 2018
Change value of OPTIMIZER MODE parameter in Oracle
Change value of OPTIMIZER MODE parameter in Oracle
Optimizer Mode Parameter in Oracle
Optimizer choose the execution plan according to the value of OPTIMIZER MODE parameter for all rows it check all rows for session to choose better execution plan . It has different values you can set as you need.
Default value is ALL_ROWS
You can set is at session or system level for testing or permanent changes at database level.
First_rows_nOptimizer used a…
View On WordPress