Re: are hints still necessary in 9i?

From: mcstock <mcstock_at_enquery.com>
Date: Thu, 23 Oct 2003 17:17:51 -0400
Message-ID: <caidnYaaNskB2AWiRVn-uA@comcast.com>

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

"Charles J. Fisher" <cfisher_at_rhadmin.org> wrote in message news:Pine.BSO.4.53.0310231401250.22116_at_bart.rhadmin.org...
> On Wed, 8 Oct 2003, Ryan Gaffuri wrote:
>
> > Tom Kyte swears that if you properly analyze your table, the CBO is at
> > the point where you never need hints. I find I still need them
> > 'occasionally', though not very often.
>
> > anyone else have opinions? anyone who beta tested 10g see an
> > improvement in the CBO? IT tends to get a little better with each
> > release.
>
> Umm... I've never used it, but don't you need hints to control parallel
> query?
>
> Wouldn't there be cases where the NOCACHE hint would be useful for an
> infrequent full table scan where you don't want to disturb the block
> buffers?
>
> Is it unfathomable that one might want to switch to all_rows, first_rows,
> choose, or rule in a sql statement without issuing an alter session?
>
> ----------------------------------------------------------------------

---

> / Charles J. Fisher | "Fascism should more properly be called
/
> / cfisher_at_rhadmin.org | corporatism, since it is the merger of state
/
> / http://rhadmin.org | and corporate power." -- Mussolini
/
> --------------------------------------------------------------------------
- Received on Thu Oct 23 2003 - 16:17:51 CDT