Optimizer mode that MTO should use.
Once the MTO job is finished, this session parameter is reset to the value that was in effect before the job started.
-
Module(s) affected by this setting: R2001
-
Valid values: CHOOSE, RULE, FIRST_ROWS, ALL_ROWS
Optimizer mode that MTO should use.
Once the MTO job is finished, this session parameter is reset to the value that was in effect before the job started.
Module(s) affected by this setting: R2001
Valid values: CHOOSE, RULE, FIRST_ROWS, ALL_ROWS