DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: urgent

  1. #11
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: rebuilding indexes

    Originally posted by m00nminkey

    You need to be careful playing with indexes using the RB0 (Rule based) as you effect the database performance!

    m00n
    Why using RBO? It's like running a Mercedes Benz with a Trabant engine :-)

    And you might not have heard but there will be no RBO in 10i.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  2. #12
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Since 1991 in every release Oracle has been saying that RBO would not be supported, but Oracle kernel developers and designers do not know how to rewrite their own code to utilize the CBO features. That is why they still supported RBO. I do not think RBO will be totally eliminated in 10i.

  3. #13
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by tamilselvan
    Since 1991 in every release Oracle has been saying that RBO would not be supported, but Oracle kernel developers and designers do not know how to rewrite their own code to utilize the CBO features. That is why they still supported RBO. I do not think RBO will be totally eliminated in 10i.
    Read 189702.1: Rule Based Optimizer is to be Desupported in Oracle10i.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

Posting Permissions

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


Click Here to Expand Forum to Full Width