RULE Base Vs COST Base in Oracle8.0.5
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: RULE Base Vs COST Base in Oracle8.0.5

  1. #1
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    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
    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

  2. #2
    Join Date
    Aug 2002
    Posts
    1

    Reply: RULE vs COST Based opt

    Hi,

    The cost based optimizer will always give you better results. This is provided Oracle
    has the statistics of the user objects generated continuously. You should always
    ANALYZE user objects regularly so that Oracle has the true and the latest statistics
    to draw up an execution plan for Cost Based Optimizer.

    Cheers!!
    Ajay
    Technical Consultant

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