Re: Precompiled statement?

On Apr 22, 9:13 am, Taras_96 <taras...@xxxxxxxxx> 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
.

Relevant Pages

  • Re: 10.2 Bug?
    ... SQL> CREATE OR REPLACE PROCEDURE dead_code AS ... Procedure created with compilation warnings ... 4/8 PLW-06002: Unreachable code ... PLSQL_OPTIMIZE_LEVEL specifies the optimization level that will be used to ...
    (comp.databases.oracle.server)
  • Re: 10.2 Bug?
    ... SQL> CREATE OR REPLACE PROCEDURE dead_code AS ... Procedure created with compilation warnings ... 4/8 PLW-06002: Unreachable code ... PLSQL_OPTIMIZE_LEVEL specifies the optimization level that will be used to ...
    (comp.databases.oracle.server)
  • Re: Precompiled statement?
    ... I've read a bit about precompiled SQL statements. ... What exactly is done in order to change a normal inline SQL ... sent to the DBMS for parsing and compilation. ...
    (comp.lang.java.databases)
  • Re: heavy-weight macros
    ... verify that SQL expression is correct according to current database schema ... to database schema ... I'm not aware of any SQL library that can check query syntax without ... compilation of sources, and it might be not efficient (query planning ...
    (comp.lang.lisp)
  • Re: Precompiled statement?
    ... I've read a bit about precompiled SQL statements. ... What exactly is done in order to change a normal inline SQL ... sent to the DBMS for parsing and compilation. ...
    (comp.lang.java.databases)