Hints in Practice

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 Received on Tue Aug 22 2006 - 12:15:07 CDT