A static SQL statement is embedded within an application program. All these embedded statements must be precompiled and bound into a package before the application can be executed.
When DB2 compiles these statements, it creates an access plan for each one that is based on the catalog statistics and configuration parameters at the time that the statements were precompiled and bound.
These access plans are always used when the application is run; they do not change until the package is bound again.
The alternative to static SQL is dynamic SQL.
[ Top of Page | Table of Contents | Glossary | Index ]