SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
9-132
Examples of QUERYCACHE
NUM_PIN_HITS_PARSING 0
NUM_PIN_HITS_BINDING 0
NUM_CACHEABLE_TOO_LARGE 0
NUM_DISPLACED 0
OPTIMIZATION_LEVEL 3
PINNING_STATEOFF
--- 1 row(s) selected.
•
Display selected query plan caching statistics from the same query:
SELECT NUM_RETRIES, OPTIMIZATION_LEVEL FROM TABLE
(QUERYCACHE ());
NUM_RETRIES OPTIMIZATION_LEVEL
---------- ------------------
0 3
--- 1 row(s) selected.