Results 1 to 2 of 2

Thread: RBO question

  1. #1
    Join Date
    Jan 2003
    Location
    Atlanta
    Posts
    134

    Unanswered: RBO question

    Hi,

    I have software package that has Rule Based Optimization and in the init.ora file in Oracle-8i the optimization flag is set RULE. I can not upgrade to CBO because of software package.

    If I do ANALYZE ON TABLES OR SCHEMAS does it benefit anything in performance? Some say it will harm the existing RBO queries. Is this correct? Do I need to clear all the analyze optimization data from the tables what I did as test before posing this question?

    Thanks for any suggestion

    Vinnie

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Yes, you should delete statistics on objects if you are running RULE based optimization.

    execute dbms_utility.analyze_schema('SCHEMA','DELETE');

    Gregg

Posting Permissions

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