SQL/MX Glossary

Glossary
HP NonStop SQL/MX Glossary—523732-002
Glossary-12
execution plan
of information about the execution upon completion. Each SQLJ clause in a Java
program is implicitly or explicitly associated with an execution context.
execution plan. An execution method, including the semantics and execution
characteristics, for a single compiled SQL statement. The SQL compiler stores the
execution plan in an SQL module during explicit compilation, and the SQL executor
uses the plan to execute the SQL statement at run time. Dynamic SQL statements
create an execution plan when the dynamic SQL statement is executed. Compiled
programs typically include many plans.
execution-time name resolution. The resolution of a name of an SQL object in an SQL
statement performed at statement execution time rather than during explicit SQL
compilation.
executor. The SQL/MX component that executes compiled SQL statements that access
database tables, views, and stored procedures. The executor executes a DML
statement by using the query execution plan chosen by the optimizer. If necessary, the
executor calls the SQL compiler to recompile a program or statement.
executor predicate. A predicate that must be evaluated by the executor.
executor server process (ESP). See ESP.
EXPLAIN function result. A table-valued result of the EXPLAIN function that returns
information about query operators describing the access plan for a DML statement.
The entries in the table describe an operator tree. See also EXPLAIN operator tree.
EXPLAIN operator tree. A tree structure that represents operators used in an access plan
as nodes (events in the plan), with at most one parent node for each node in the tree,
and with only one root node. Each node might have subordinate nodes.
explicit correlation name. A correlation name specified in the FROM clause of a SELECT
statement as an alternate name for a table or a view. Contrast with implicit correlation
name.
explicit SQL compilation. The SQL compilation of a program initiated by running the SQL
compiler (mxcmp). The SQL compiler generates a program. Contrast with automatic
SQL recompilation.
expression. A representation of a value. An SQL value expression has a data type:
character, datetime, interval, or numeric.
extended profile. A.ser file containing the customized profile that the SQLJ customizer
generates.
externally qualified module name. The three-part module name
(catalog.schema.module) can contain these externally qualified attributes: table
set, version, and group. The module name is externally qualified by using specific
preprocessor or customizer options on the command line. For example, the module