Re: Hints in Practice

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 27 Aug 2006 11:16:25 -0700
Message-ID: <1156702585.746264.68470@b28g2000cwb.googlegroups.com>

Bob Jones wrote:
>
> That is correct. Oracle is about the only database I know uses explicit
> hints. That is not really a vote of confidence in their optimizer.
>
> I would do anything to avoid using those hints. They are not portable and do
> not conform to any standard. It is almost always possible to build good
> performing queries without hints.

"Almost always possible" ... don't the 2 words on either side of always make your statement meaningless.

Read Jonathan's Lewis response and his books.

Dial back into this debate when you understand what you are talking about. Received on Sun Aug 27 2006 - 13:16:25 CDT