Re: Precompiled statement?

by "joeNOSPAM@[EMAIL PROTECTED] " <joe.weinstein@[EMAIL PROTECTED] > Apr 22, 2008 at 12:26 PM

On Apr 22, 9:13 am, Taras_96 <taras...@[EMAIL PROTECTED]
> wrote:
> Hi all,
>
> I've read a bit about precompiled SQL statements. However, I haven't
> been able to find anything which explains what the compilation process
> entails. What exactly is done in order to change a normal inline SQL
> statement into a precompiled one?
>
> Thanks
>
> Taras

The major benefit possible by re-using Prepared/CallableStatements
is that when you create them, you supply the SQL, which can be
sent to the DBMS for parsing and compilation. The resultant query
plan is retained by the DBMS, and re-used as long as the statement
remains open. The saving is that a plain statement would have to
as the DBMS to parse and compile it's SQL for every execution.

Joe Weinstein at BEA Systems