Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: are hints still necessary in 9i?

Re: are hints still necessary in 9i?

From: mcstock <mcstock_at_enquery.com>
Date: Thu, 23 Oct 2003 21:19:07 -0400
Message-ID: <sMGdnRRjvNG14wWiRVn-hg@comcast.com>


if we do an apples to apples, with the developer testing with a realistic data set and test environment -- i'd still give a lot more then 0.1% margin of error to the CBO. what i've think you may have identified is the CBO becoming a better safety net for developers that don't (or can't) test adaquately

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1066949637.846158_at_yasure...
> mcstock wrote:
>
> >never say never
> >
> >as the CBO improves, hints may be needed less
> >
> >however we can never say that the CBO will always be smarter than the
> >developer (or that the CBO developers will always be smarter than the
> >application developers)
> >
> >----------------------------------------
> >Mark C. Stock
> >www.enquery.com
> >(888) 512-2048
> >
> >
> True. But I'd venture that 99.9+% of the time the CBO is smarter than
> the developer that
> developers on a DEV instance with a bit of sample data and a few users,
> and then moves
> the application into TEST with six month old clone of a subset of
> production data and a
> dozen users, at most, that then gets moved into the full PROD instance
> with 1000 users
> beating it up full-time 7x24.
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
Received on Thu Oct 23 2003 - 20:19:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US