Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Using Bind Variable & Hard Parsing --- All or Nothing ?

Using Bind Variable & Hard Parsing --- All or Nothing ?

From: R Chin <rchin_at_panix.com>
Date: Tue, 23 Jul 2002 12:04:54 -0400
Message-ID: <ahjur7$cav$2@reader3.panix.com>


8.1.7/AIX Is the usage of bind variable and the prevention of re-hard-parse an ALL-OR-NOTHING
kind of situation ?

I mean if in an SQL there are 5 places where BV should be used but I missed one and
used only 4 BVs --- does this TOTALLY negate the 4 BVs and causing a hard-parse every time ? that Oracle treats each SQL as a different one
(for different values) ?

Thanks

Robert Received on Tue Jul 23 2002 - 11:04:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US