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

"Bosco Ng" <boscong_at_leccotech.com> wrote in message news:cd3b7a8a.0306190149.6bd8b8bb_at_posting.google.com...

>
> Then what's DB2's Optimizer Level (1 to 9 if I remember right)?
>
> DB2's optimizer is neither smarter nor dumber, but more rigid in its
> behavior and more abstract. For a SQL statement, you can only specify
> level 1 to level 9 to adjust the level of rewrite done by DB2's
> optimizer. But which level's best? God knows.

SSSShhhhhhhhh! If you don't explain the crud that passes for their "optimizer", they can continue to claim it brews coffee as well.

Nothing like a little x-knowledge
to debunk marketing crap, eh? ;)

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