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

"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 Thu Jun 19 2003 - 12:35:18 CDT