RE: hinting and the rule based optimizer

From: <Satheesh.Babu_at_iflexsolutions.com>
Date: Fri, 2 Apr 2004 10:31:35 +0530
Message-ID: <10898BE7CA96D611988B000802255AAF05C0DE2B@fmgrt>

IIRC UNNEST and DRIVING_SITE is are the two hint which uses RBO apart from RULE hint.

Thanks and Regards,
Satheesh Babu.S

DISCLAIMER:
This message contains privileged and confidential information and is = intended only for the individual named.If you are not the intended = recipient you should not disseminate,distribute,store,print, copy or = deliver this message.Please notify the sender immediately by e-mail if = you have received this e-mail by mistake and delete this e-mail from = your system.E-mail transmission cannot be guaranteed to be secure or = error-free as information could be =
intercepted,corrupted,lost,destroyed,arrive late or incomplete or = contain viruses.The sender therefore does not accept liability for any = errors or omissions in the contents of this message which arise as a = result of e-mail transmission. If verification is required please = request a hard-copy version.

---

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 Thu Apr 01 2004 - 22:55:33 CST