SQL/MX Comparison Guide for SQL/MP Users

DML Features
HP NonStop SQL/MX Comparison Guide for SQL/MP Users—523735-003
3-25
Query Caching
When caching
change takes effect
On next system configuration
refresh.
At next query compile.
Ownership of object Cache per ODBC/MP server. Cache per MXCMP process.
When cache is
flushed
When Guardian user ID
changes. CONTROL
statements only affect the
next statement compilation,
which is avoided when a
statement is used from
cache. Cache is not
preserved over critical
condition termination. All
statements are flushed at
server reinitialization.
On demand. User requests
cache size be reduced to
zero by issuing CONTROL
QUERY DEFAULT
QUERY_CACHE '0'
statement.
Cache statistics Logged in MP table. In-memory counters.
When statistics are
saved and reported
Performed by server, either
at statement close or at
session disconnect.
In-memory counters are
retrieved when user issues
SELECT … FROM
table(querycache())
WHERE …
and
SELECT … FROM
table(querycacheentri
es()) WHERE …
statements.
Feature NonStop SQL/MP NonStop SQL/MX