Re: sources for hidden and useful hints for testin

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 24 Jul 2004 00:27:18 +0100
Message-ID: <045101c4710c$9a263d00$7102a8c0@Primary>

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_at_askddbc.com> To: <oracle-l_at_freelists.org> 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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Fri Jul 23 2004 - 18:23:54 CDT