SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—544517-008
9-115
Examples of QUERYCACHE
•
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.