Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Migrating to cost based optimizer
Dear group,
Our applications are supporting Oracle 8.1.7 and Oracle 9, for many customers with varying level of activity. We use the rule based optimizer to ensure the stability of the sql statement's execution plans.
We are thinking of moving to the cost based optimizer, at least in Oracle 10.
Would you have a strategy to recommand ?
What is the first Oracle release with a cost based optimizer working reasonably well ?
How do you check the performances of your applications across oracle releases and customers with that optimizer ?
Thanks. Received on Sat Sep 23 2006 - 03:37:59 CDT
![]() |
![]() |