Re: Hints in Practice

From: Bob Jones <email_at_me.not>
Date: Wed, 23 Aug 2006 15:47:37 GMT
Message-ID: <tM_Gg.14320$9T3.13868@newssvr25.news.prodigy.net>

"Robert Klemme" <shortcutter_at_googlemail.com> wrote in message news:4l2ss9Fb4aU1_at_individual.net...
> On 23.08.2006 02:41, 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.
>
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_fa-fz_4ox9.asp
> http://msdn2.microsoft.com/en-us/library/ms187713.aspx
>
> IBM offers "hints" for DB2, although these seem rather backward (forging
> table statistics vs. explicitly stating indexes to use):
>
> http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db2.doc.admin/bjndmstr663.htm
>
> You see, it seems not to uncommon to have hints as a DB feature.
>

Good links. I have worked with DB2 for years and have never even heard of those hints. In fact, I have never seen a single line of code with hints. 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. Received on Wed Aug 23 2006 - 10:47:37 CDT