Re: Where can I get a complete list of all SQL Hints?

> Absence of hints might be proof enough.

Absence of hints means better optimizer???? And you base your arguments on that?
Hmmm... might be Access is better than both Oracle and DB2 UDB coz it doesn't have hints and optimizer level settings ....

It's just the same wolf under different cover and I found the optimizer level (and those FOR READ ONLY and blah blah blah ..) more abstract and difficult to use when I need to tune a SQL statement. (yes, I know Hints and optimizer level should be last resort but somehow you just can't guarantee the optimizer makes 100% correct decision for you, do you?)

> Yeah, but every predecessor version of DB2 since the very beginning
> had a cost-based optimiser, i.e. well over a decade before Oracle. So
> it's you talking crap.

Yes, so is IBM to Oracle. The earlier presence of CBO does not make it a better one.

> DB2 UDB for multi-platforms doesn't support hints of any kind, like I
> said.

Sybase on any platform does not support hints either. They called them Options and Forces. How about that? Oh, Forces aren't hint, so Sybase must be better than Oracle. What a simple comparison and mind inspiring notion.

"TM" <tonym101_at_hotmail.com> wrote in message news:7b718442.0306190935.122a53e7_at_posting.google.com...
> "Noons" <wizofoz2k_at_yahoo.com.au.nospam> wrote in message
news:<3ef165cc$0$24424$afc38c87_at_news.optusnet.com.au>...
>
> > > DB2 UDB is widely recognised as having
> > > the leading optimizer though.
> >
> > Bullshit. Prove it, instead of quoting marketing crap.
>
> Absence of hints might be proof enough.
>
> > > Oracle still needs hints because it's
> > > playing catch up.
> >
> > Really? I seem to recall Oracle getting a CBO
> > BEFORE UDB existed as a product. Funny kind
> > of "catch up". I guess the kind that IBM marketing
> > crap uses?
>
> Yeah, but every predecessor version of DB2 since the very beginning
> had a cost-based optimiser, i.e. well over a decade before Oracle. So
> it's you talking crap.
>
> > > Believe DB2 For OS/390 has some feature once billed as vaguely akin to
> > > "hints" but which in fact involves storing the hint in the catalog.
> >
> > Of course it does. And has had for a long time.
>
> Whatever that feature is intended for, it hasn't had it even a quarter
> as long as Oracle.
>
> > > Maybe that's what you meant. This still doesn't involve coding hints
> > > into your SQL though.
> >
> > You say tomah-to, I say toma-to.
> > It has an equivalent feature.
>
> DB2 UDB for multi-platforms doesn't support hints of any kind, like I
> said.
>
>
> TM
Received on Fri Jun 20 2003 - 09:30:57 CDT