dynamic/static sql in DB2/Oracle
From: Frank Leenders <ftleenders_at_hotmail.com>
Date: Tue, 9 Feb 1999 10:47:47 +0100
Message-ID: <79p0jr$9gn$1_at_koza.nl.net>
Hello all,
at the moment I work in a DB2 environment and the experts all talk about dynamic and static SQL. It seems that SQL has to go through a 'bind' proces (some kind of precompiling) to make it static in order to have good performance. Static SQL is discouraged.
In the Oracle world I never heard about such a difference and I never encountered the term during my Oracle work. Is it correct to assume that Oracle 'binds' at runtime (by the optimizer). Thanx
Frank Received on Tue Feb 09 1999 - 10:47:47 CET
Date: Tue, 9 Feb 1999 10:47:47 +0100
Message-ID: <79p0jr$9gn$1_at_koza.nl.net>
Hello all,
at the moment I work in a DB2 environment and the experts all talk about dynamic and static SQL. It seems that SQL has to go through a 'bind' proces (some kind of precompiling) to make it static in order to have good performance. Static SQL is discouraged.
In the Oracle world I never heard about such a difference and I never encountered the term during my Oracle work. Is it correct to assume that Oracle 'binds' at runtime (by the optimizer). Thanx
Frank Received on Tue Feb 09 1999 - 10:47:47 CET