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

Telemachus wrote:

> There is nothing wrong with research; a little work by the poster would have
> taken him to a useful thread on this NG entitled 'Hash Join Order'
> which kicked off 27/3/03 which discussed these things at the end and was
> contributed to by several luminaries (connor and jonathan for two ) .
>

I agree with your sentiment.

All I suggest is covering the request for information with a statement that this is for information & research purposes. There are too many people who will try stuff they've seen in newsgroups because 'an expert recommended it', and undocumented hints are in the 'potentially dangerous for the health of the database' category.

> My own research shows there is little on the web and less on metalink
> devoted to explaining undocumented hints.

Undocumented hints are undocumented for a few reasons. As far as I can tell these hints drive code that is effectively in beta (or at least under development evaluation) and should not be used yet, unless explicity advised by a group (Oracle Support) who will take responsibility for their use.

I'm not sure why people expect there to be documentation for something we are not supposed to know about <g>

I'm also don't understand why most people would spend the effort/time to study something like this, which can change at any time with the release of patches. The Oracle product set is so big, a person can easily spend years in thoroughly learning the 'legitimate' areas. (Operative word "most" excludes the Connors and Jonathans of our world.) Received on Fri Jun 20 2003 - 09:59:33 CDT