RE: ** to outline or not to

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Wed, 26 Oct 2005 16:47:19 +0200
Message-ID: <F2C9CCA71510B442AF71446CAE8AEBAF1BBD6A@MSXVS04.trivadis.com>

Amit

> So that means outlines will be a problem if you are hard parsing a lot. ?
>
> But hard parsing a lot itself is a problem which needs to fixed first
> Correct ?

IMHO even if you have a lot of hard parses outlines will not be a problem. Why? Because if you created some outlines that means that without them the performance is really bad! Of course they have to be processed and an overhead cannot be avoided. Anyway, IMHO, the overhead is usually very small.

Regards,
Chris

New Features Oracle Database 10g Release 2 seminars @ www.trivadis.com <http://www.trivadis.com> Italiano: Lugano (24-Nov)
Français: Genève (17-Nov)
Deutsch: Düsseldorf (23-Nov), Zürich (29-Nov), Stuttgart (13-Dec)

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Oct 26 2005 - 09:50:24 CDT