RE: Stored outlines

From: Norris, Gregory T [ITS] <gregory.t.norris_at_mail.sprint.com>
Date: Wed, 25 Feb 2004 14:00:18 -0600
Message-ID: <D24DD765BFEDB145B346ACDA71E1658B03AB124C@PKDWB04C.ad.sprint.com>

I'm using a handful of them under 8.1.7, for a 3rd-party app which we aren't able to modify. I've never noticed any CBO-related problems (none related to the use of stored outlines, anyway ;-)... it works rather well, actually.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Gudmundur Josepsson Sent: Wednesday, February 25, 2004 11:44 AM To: oracle-l_at_freelists.org
Subject: Stored outlines

Is anybody using stored outlines in production? There has been some talk about outlines being a great tool to optimize SQL statements without having access to the source, which to me seems to be the best reason to use them. Others have said that using stored outlines interferes with the CBO and that you'd be just as well off with the RBO.

Any thoughts?

Gudmundur

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 Wed Feb 25 2004 - 13:58:52 CST