Re: Hints in Practice

DA Morgan wrote:
> Bob Jones wrote:
> > "Frank van Bortel" <frank.van.bortel_at_gmail.com> wrote in message
> > news:eci4dg$ijv$1_at_news6.zwoll1.ov.home.nl...
> >> Bob Jones schreef:
> >> [snip]
> >>> The use of hints is discouraged. If you go to one of those DB2 classes,
> >>> they will tell you the same.
> >>>
> >>> I am not sure about SQL Server. Will they encourage the use of hints? I
> >>> doubt.
> >> Neither does Oracle. Use hints as a last resort, that's the
> >> general consensus...
> >>
> >
> > Hmmm, I wonder why there are so many use of hints only in Oracle
> > applications.

>

I read that as Oracle Applications (the products, not applications in general). In which case, I'd say, a lot of the code predated optimizer features and bugfixes, and perhaps some was written in ignorance of, well, what Oracle experts know now. That could be said of any large system that's been around for a while, so for Bob to use it to imply that since Oracle does it, Oracle is saying everyone should, is wrong. Aside from that, it is a good point, unless Oracle is rewriting every application. Wouldn't that be the "Fusion" thing Larry goes on about?

jg

-- 
@home.com is bogus.
Why is my computer making that funny noise?