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

Ryan wrote:

> i have found the oracle documentation to be very good. However, I have also
> found that some of the best information has been written by people who do
> NOT work for oracle.

While I have observed the same, I have also found an awful lot of unmitigated garbage written about Oracle by people who do not work for Oracle. It's a 'buyer beware' situation.

Bluntly, I'd hesitate sourcing any information not sanctioned by the Oak Table, unless it was co-written by some names I met personally & trust (like Stackowiak and Muensch.)

Asking the question in view of all the lurkers (many are likely newbies) without raising the qualifications - that I believe YOU really do know and understand - can run these same lurkers into a rathole. That causes me some concern. (Although I do understand your enthusiasm and your test-at-home environment as it reminds me of myself in the 6.0 - 7.2 days).

Aside from that, I feel your question is actually quite impractical. Any kernel level patch could add or remove undocumented hints without warning. Therefore a simple list is not sufficient as each undocument hint would need to be supported by at least the versions/patch-levels first and last detected, whether it appears to be deprecated or new, and whether it has been regression tested as performing the same function as previously thought. (A database!)

That said - I think a more interesting question is "who has been advised by Oracle Support to use an undocumented hint & what were the circumstances/reasons?"

/Hans Received on Sat Jun 14 2003 - 21:01:54 CDT