RE: Should we stop analyzing?

Yeah, copped a copy of 10g new features from somewhere, but it was sorely lacking in detail. I seem to have missed the CBO bit.

Jared

On Thu, 2004-01-08 at 10:49, Jamadagni, Rajendra wrote:
> Right Jared,
>
> But this is where the new 'learning CBO' comes into picture isn't it? in 10g CBO looks at the history and then modified the execution plans.
>
> This is all from Oracle 10g propaganda sheets, I'll agree when I see it in action.
>
> Raj
> --------------------------------------------------------------------------------
> Rajendra dot Jamadagni at nospamespn dot com
> All Views expressed in this email are strictly personal.
> QOTD: Any clod can have facts, having an opinion is an art !
>
>
> -----Original Message-----
> Sent: Thursday, January 08, 2004 1:40 PM
> To: Multiple recipients of list ORACLE-L
>
>
> > Me thinks CBO is probably never going to be bug free.
> > What works for you, won't work for me unless we run
> > identical systems, it is a general purpose system,
> > CBO doesn't know your system or data usage.
>
> At this point it would seem beneficial to differentiate between a
> bug and a logic error.
>
> Roughly, a bug would seem to be code that falls into one of
> two categories:
>
> * code that doesn't do what the developer intended
> * code that generates errors
>
> A logic error would be found in code that does exactly what
> the developer intended, but what the developer intended is
> the wrong thing to do.
>
> This could be expanded to include the inability of CBO to
> properly identify a usage pattern.
>
> just my opinion.
>
> Jared
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jamadagni, Rajendra
> INET: Rajendra.Jamadagni_at_espn.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).