Re: Hash join order

Sybrand Bakker wrote:

> On 30 Mar 2003 08:03:51 GMT, Rene Nyffenegger
> <rene.nyffenegger_at_gmx.ch> wrote:
>
> >For some reasons, Oracle corp chose not to document every hint available. But
> >it seems possible to extract possible hints out of the oracle binary with the
> >unix command strings and they should be these (ora 9.2):
>
> And evidently Oracle doesn't guarantee these hints will be retained in
> a subsequent release.
> Might that be the reason why they weren't published? I bet!
>
> As far as I am concerned promoting people to rely on undocumented
> features should be avoided. Or you must have a very good lawyer of
> course.
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

The good thing about hints is that Oracle just ignores them when they aren't correct. So the syntax:

/* +Who_Cares */ compiles just fine.

When Oracle drops support ... no harm is done.

Daniel Morgan Received on Sun Mar 30 2003 - 12:51:17 CST