SQL/MX 2.x Query Guide (G06.24+, H06.03+)

Query Plan Caching
HP NonStop SQL/MX Query Guide—523728-003
6-12
QUERYCACHEENTRIES Function
PARAM_TYPES CHAR(1024) Comma-separated list of the types
of constants that were changed into
parameters. Blank if none.
PLAN_LENGTH INT UNSIGNED Size in bytes of the compiled plan
associated with this query.
IS_PINNED CHAR(6) Indicates whether the entry is
pinned. Can be ON or OFF.
COMPILATION_TIME INT UNSIGNED Time in milliseconds it took to
compile the query associated with
this entry.
AVERAGE_HIT_TIME INT UNSIGNED Time in milliseconds it took on
average to process a query as a
cache hit against this entry.
SHAPE CHAR (1024) Required CONTROL QUERY
SHAPE of the query associated with
this entry. Blank if no required
shape.
ISOLATION_LEVEL CHAR(20) Transaction isolation level
associated with the query. Can be
READ_UNCOMMITTED,
READ_COMMITTED,
REPEATABLE_READ,
SERIALIZABLE, NOT_SPECIFIED.
ACCESS_MODE CHAR(20) Transaction access mode value
associated with the query. Can be
READ_ONLY, READ_WRITE, or
NOT_SPECIFIED.
AUTO_COMMIT CHAR(15) Transaction auto-commit value
associated with the query. Can be
ON, OFF, or NOT_SPECIFIED.
ROLLBACK_MODE CHAR(15) Transaction rollback mode value
associated with the query. Can be
WAITED, NOWAITED, or
NOT_SPECIFIED.
Column Name Data Type Description