Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: difference between soft and hard parse
Ted Chyn wrote:
>
> all, soft parse is better than hard parse. what are the definition and
> difference between the two ?
>
> thnx ted chyn
(Simplistically...)
hard parse - the whole kaboodle - brand new sql comes along - gotta do all the stuff - syntax check, privs, blah blah blah
soft parse - sql already in the pool - but mine - gotta do some of the hard parse stuff but not all of it.
hth
-- ============================== Connor McDonald http://www.oracledba.co.uk "Some days you're the pigeon, some days you're the statue..."Received on Thu Sep 06 2001 - 15:00:15 CDT