RE: OUTLN

From: Deshpande, Kirti <kirti.deshpande_at_verizon.com>
Date: Mon, 04 Feb 2002 09:44:46 -0800
Message-ID: <F001.004050F1.20020204093535@fatcity.com>

Mark,
Thanks.
We are rolling out a new system that uses Rule based optimization. And use of outlines could be useful to us. Of course, if the vendor of the product agrees to make use of it !!
I have played with the feature just a little in my test database and that's about it...

Kirti

-----Original Message-----
Sent: Monday, February 04, 2002 11:07 AM To: Multiple recipients of list ORACLE-L

Kirti,

I speak to a fair number of DBAs daily, and even bring this up with a fair few of them, and have yet to come across a single person that uses this package. We have a tool (DBExpert which is a spin-off of SQLExpert from Leccotech) that has a "Stored Outline Manager", which is basically a graphical front end that aids managing, creating, updating of Stored Outlines.

Not one person I have spoken to has lit on to this at all.. I have to say that it *does* work as advertised - we've used it to test this new function in the tool quite extensively for beta testing.. Whether it's just not widely known about (a *lot* of people ask what it actually is), or just not worth implementing I'm not sure.. I think there could be quite a good scope for them with those apps that *still* run RULE based, and want to be migrated quickly and easily to COST / CHOOSE with minimal tuning / re-write requirements..

I had no issues with them at all.. The section "Using Plan Stability" in the 8i Tuning & Performance manual was very helpful in playing with them, and explains in good detail..

HTH Mark

-----Original Message-----
Kirti
Sent: 04 February 2002 16:40
To: Multiple recipients of list ORACLE-L

Anyone really using this feature?
Care to share the experience?
Does it work as advertised? Any issues?

Thanks.
- Kirti

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Deshpande, Kirti
INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Feb 04 2002 - 11:44:46 CST