var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: cbo or rbo
our database run with optimizer_mode=rule. i have analyze the tables und indizes and want to change the optimizer_mode=all_rows.
has someone experiences with it ???
Last edited by mkoster; 10-08-02 at 08:23.
Only know rule and choose ???
do you mean the optimizer hint "all_rows". We have experiences with
optimizer_mode = rule and optimizer_mode = choose ??!?!?!?!?!
(Alligator Company GmbH)
i mean the parameter optimizer_mode in the init.ora.
i have test it with "choose" and "all_rows".
the performance is alike as also with "rule"