SQL/MX Comparison Guide for SQL/MP Users

DML Features
HP NonStop SQL/MX Comparison Guide for SQL/MP Users—523735-003
3-26
Query Caching
Cache counters Number of statements,
lookups, hits, drops.
Extended to indicate whether
statement was not cached
because it is parallel, and
parallel was not activated.
In-memory counters are:
Number of entries, pinned
entries, compiles, cachable
compiles by phase,
recompiles, retries,
cachables, hits by phase,
pinned hits by phase,
displaced, cachable-but-too-
large, current size, max size,
average plan size, max
victims, optimization level,
pinning state.
Per entry: hits, size, text,
plan ID, row ID, phase,
optimization level, catalog
name, schema name, pin,
number of parameters,
parameter types, plan length,
compilation time, average hit
time, required shape,
isolation level, access mode,
autocommit, rollback mode
setting.
Types of queries that
are cachable
ExecDirect or Prepare user
SQL DML statements,
without dynamic parameters.
ExecDirect or Prepare user
SQL DML statements.
When constant
values are bound to
a query's
system-introduced
parameters
Just before execute step in
ODBC/MP server. Literals
are transformed into
parameters during the
statement translate stage.
After generate step in
MXCMP compiler.
Feature NonStop SQL/MP NonStop SQL/MX