RE: ** to outline or not to

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Wed, 26 Oct 2005 08:12:39 +0200
Message-ID: <F2C9CCA71510B442AF71446CAE8AEBAF204E44@MSXVS04.trivadis.com>

Amit

>I thought the outlines effected only hard parses not soft parses ?
>Is that correct ?

Outlines are "added" to the SQL statements before the generation of the execution plan. Since soft parses don't re-generate the execution plan... it's correct to say that they affect hard parses only.

Regards,
Chris

New Features Oracle Database 10g Release 2 seminars @ 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 - 01:14:48 CDT