Re: difference between soft and hard parse

From: Anurag Varma <avdbi_at_nospam.hotmail.com>
Date: Thu, 06 Sep 2001 19:40:39 GMT
Message-ID: <XiQl7.2174$tb.384090@news02.optonline.net>

parse = When a sql statement is issued, this translates it into an execution plan,

               including checks for proper security authorization and check for the

               existence of tables, columns, and other referenced objects

hard parse = Happens when a new SQL statement is issued which does not exist in the shared pool.

                    This query then has to be parsed fully. Considered as
expensive both in terms of CPU used
                    as well as in the number of latches gets performed.

soft parse = Happens when a new SQL statement is issued which ALREADY exists in the shared pool.

                   Hence this query is already parsed. Thus the already

available execution plan etc. is reused.

Anurag

"Ted Chyn" <tedchyn_at_yahoo.com> wrote in message news:44a19320.0109061113.19ee035b_at_posting.google.com...
> all, soft parse is better than hard parse. what are the definition and
> difference between the two ?
>
> thnx ted chyn
Received on Thu Sep 06 2001 - 14:40:39 CDT