Re: Remote query puzzle

On 9/8/05, Mladen Gogala <gogala_at_sbcglobal.net> wrote:
> > That also requires CBO. Dennis is working with RBO.
>
> Actually, there is no real reason for that. One can switch
> from RBO to CBO from query to query.

Maybe so, I haven't tried it.

Might it not complicate other queries?

If there are stored plans, does the optimizer then use CBO on other statements that include the table that has the stored plans?

If so, the assumptions made by the CBO about those tables might lead to less than satisfactory execution plans, requiring hinting of SQL, or more stored plans.

Stuff to think about - I don't have time to test it now myself.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
11+ years of trying to appear to know what I'm doing.
--
http://www.freelists.org/webpage/oracle-l