Results 1 to 3 of 3

Thread: cbo or rbo

  1. #1
    Join Date
    Oct 2002
    Posts
    55

    Unanswered: cbo or rbo

    hi,

    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 ???

    thanks
    marcus
    Last edited by mkoster; 10-08-02 at 09:23.

  2. #2
    Join Date
    Jul 2001
    Location
    Germany
    Posts
    189

    Question Only know rule and choose ???

    Hello,

    do you mean the optimizer hint "all_rows". We have experiences with
    optimizer_mode = rule and optimizer_mode = choose ??!?!?!?!?!

    Regards
    Manfred Peter
    (Alligator Company GmbH)
    http://www.alligatorsql.com

  3. #3
    Join Date
    Oct 2002
    Posts
    55
    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"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •