There are quite a lot of hints which are undocumented - of which a couple appear only on metalink, and some in the recursive SQL used by the database. I suspect some hints are undocumented because they were simply overlooked when the manuals were being written. Some are clearly not supposed to be available to end-users. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/seminar.html Optimising Oracle Seminar - schedule updated July 20th ----- Original Message ----- From: "Justin Cave" <justin@xxxxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Saturday, July 24, 2004 12:02 AM Subject: RE: sources for hidden and useful hints for testin What hints are you talking about? So far as I'm aware, all the valid SQL hints are in the Optimizer Hints chapter of the Performance Tuning Guide http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/hintsref .htm#8326 Justin Cave Distributed Database Consulting, Inc. http://www.ddbcinc.com/askDDBC ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------