Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Location
    Shanghai , China
    Posts
    63

    Unanswered: RULE Base Vs COST Base in Oracle8.0.5

    Hi , Gurus
    Do you have any comment that which optimizer should be recommended to use in Oracle8.0.5 ?

    In Oracle7.3 , My Application is running very well under
    cost based optimizer . It saved a lot of time to tune the individual SQL . But I have no idea whether it's suitable for Oracle8.0.5 version
    Oracle is an ocean . I am just a little fish

  2. #2
    Join Date
    Jun 2001
    Location
    The Netherlands
    Posts
    38
    The cost based optimizer improved over time. You are running an old version of Oracle so you may not get the best results.
    Best way to find out if your performance will improve by using the cost based optimizer is to benchmark your application.

    It may turn out that some parts improve while other parts show a decrease in performance...

Posting Permissions

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