Is rule based optimizer aged out ?

[atkinson]

Hi,

Is rule based optimizer no longer exists in 10G, if this is true, how about the some 3rd party applications which were forced to use rule based optimizer at the statements level?.

Has any one gone though these kind of issues after the database was migrated to 10G from lower versions?.

Please advice.

Thanks,

[slimdave]

Third-party vendors would specify the compatibility of their products with different Oracle versions -- if they "support" 10g then you culd upgrade to it.

I'm not sure that 10g has no RBO, I believe that it's just officially not supported.

[KenEwald]

in 10.1.0.3

alter session set optimizer_goal=rule;
returns
ORA-01986: OPTIMIZER_GOAL is obsolete

however...

PROJECTS table
last analyzed 03/13/2005 05:43:40

select count(project_id) from projects
SORT AGGREGATE
INDEX FULL SCAN PROJECTS_PK

select /*+ rule */ count(project_id) from projects
SORT AGGREGATE
TABLE ACCESS FULL PROJECTS

select /*+ index(projects_pk) */ count(project_id) from projects
SORT AGGREGATE
INDEX FULL SCAN PROJECTS_PK

[davey23uk]

thats because it is optimizer_mode now

[KenEwald]

Word.