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 - 03:50:15 CST
