Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Hints in Practice
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