Re: Hash join order

Hi!

I'd say that one shouldn't concentrate on learning what all the undocumented tricks do. Usually undocumented means unsupported and unpredictable when versions change. Better study optimal design or (sql) coding practices. One should use undocumented features only when nothing else helps. Lot of people are persuaded to play around with all kinds of hidden parameters to "solve" their performance issues whilst not solving the roots of problem (sql, bad design, bottlenecks etc.)

So, in some sense it'd be even better if you didn't know all the hidden parameters that distract you from the "correct" way of doing things. Relying too much of undocumented parameters and nifty features will eventually make your life even harder.

Tanel.

> 2. to properly use the most outrageous options such /* +_MAJOR_TOM */
> /* +_EMMINEM */, or /* +EVEN_FASTER */
> I would also need some documented insight in the workings of
> any particular undocumented hint.
>
> Connor ? John ? Richard? (ex)insiders ?
>
> TIA,
>
> PdV
Received on Mon Mar 31 2003 - 13:32:18 CST