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

"Hans Forbrich" <forbrich_at_telusplanet.net> wrote in message news:3EEB2971.DEB1643C_at_telusplanet.net...
> Ryan wrote:
>
> >
> > i was hoping someone outside of oracle put together a list of all the
oracle
> > hints including the undocumented ones in one place with an explanation
of
> > what they do.
> >
>
> why go outside of Oracle when they are willing to document them? (btw - I
am
> not an oracle employee, so the list and the explanations in the doc have
been
> provided to you by someone outside of oracle <g>)
>
> > how many undocumented hints are useful? has anyone used them?
>
> yes, undocumented hints can be useful for the following situations:
>
> 1) when advised by Oracle's support or
> 2) when you want to explicitly null your support contract
>
> for the sake of those who will be reading the list you eventually publish,
> please put - in extremely bold letters - that undocumented hints are
probably in
> the process of being deprecated (possibly because they don't work or they
are
> superceeded) OR are under development and should be treated like any
potentially
> unstable development (read alpha/beta) code.
>

Hans,

My conclusion is that this guy is:

1. Quite bright; he has been pursuing Oracle knowledge for some time ow - although maybe he could be criticised for asking questions in the group when they could well have been answered by reading the manual.
2. Due to his 'hacker' attitude; entirely unemployable.

Regards,
Paul Received on Sat Jun 14 2003 - 16:33:48 CDT