Re: Cost Based Optimizer

First of all you don't give any information such as Oracle version. Secondly, the CBO is basically a calculator. Feed in the same numbers and you will get the same result, Conversely, if you get different results, then some of the inputs were different. Without knowing any more about the specifics like Oracle version, the sql (e.g. id it using literals of bind variables), the type and structure of the tables involved, I don't want to even begin speculating.

At 02:04 PM 5/19/2005, Terry Barnett wrote:

>I am having issues with execution plans changing even though the
>statistics on tables are kept static. Can anyone give me any information
>on the dynamic factors which are taken into account by the CBO when
>determining an execution plan and how one could detect that a plan may
>be about to change.

Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com

--
http://www.freelists.org/webpage/oracle-l