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

"TM" <tonym101_at_hotmail.com> wrote in message news:7b718442.0306181730.2ab7f95e_at_posting.google.com...

> DB2 UDB is widely recognised as having
> the leading optimizer though.

Bullshit. Prove it, instead of quoting marketing crap.

> 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?

>
> 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.

> 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.
Check the doco.

--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam