RE: ** to outline or not to
- From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
- To: "amit poddar" <amit.poddar@xxxxxxxx>
- Date: Wed, 26 Oct 2005 08:12:39 +0200
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)
--
//www.freelists.org/webpage/oracle-l
Other related posts:
