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: Hints in Practice

Re: Hints in Practice

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 22 Aug 2006 19:57:23 +0200
Message-ID: <ecfg94$mfp$2@news1.zwoll1.ov.home.nl>


Robert Klemme schreef:
>
> All,
>
> from what I read and from my limited personal experience, hints are
> superfluous most of the time. The general recommendation seems to be
> "make sure your schema is properly done, create appropriate indexes,
> make sure statistics are up to date and let the CBO do its work". Hints
> seem to be useful only in very rare cases (bugs?) where the CBO doesn't
> come up with an appropriate plan. Is this a correct summary of the
> situation or did I miss something?
>
> Thanks
>
> robert

This pretty much sums it up.
And you're in good company, Thomas Kyte thinks similarly.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Tue Aug 22 2006 - 12:57:23 CDT

Original text of this message

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