SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
8-141
Examples of QUERYCACHEENTRIES
Dept/Num Dept/Name Mgr Rpt/Dept Location
-------- ------------ ----- -------- ------------------
1000 FINANCE 23 9000 CHICAGO
1500 PERSONNEL 213 1000 CHICAGO
2000 INVENTORY 32 9000 LOS ANGELES
.
.
.
--- 12 row(s) selected.
>SELECT * FROM JOB;
Job/Code Job Description
-------- ------------------
100 MANAGER
200 PRODUCTION SUPV
250 ASSEMBLER
.
.
.
--- 10 row(s) selected.
>SELECT * FROM TABLE (QUERYCACHEENTRIES ());
ROW_ID PLAN_ID TEXT ENTRY_SIZE
------ ------------------ -------------------------- ----------
0 211894097543468116 select * from employee; 32410
1 211894097552547493 select * from job; 24968
2 211894097548497817 select * from dept; 29730
NUM_HITS PHASE OPTIMIZATION_LEVEL CATALOG_NAME SCHEMA_NAME
-------- ---------- ---------------------- ------------ -----------
1 BINDING 3 SAMDBCAT PERSNL
0 BINDING 3 SAMDBCAT PERSNL
0 BINDING 3 SAMDBCAT PERSNL
NUM_PARAMS PARAM_TYPES PLAN_LENGTH IS_PINNED COMPILATION_TIME
---------- ----------- ----------- --------- -----------------
0 31752 OFF 334
0 24504 OFF 54
0 29144 OFF 96
AVERAGE_HIT_TIME SHAPE ISOLATION_LEVEL ACCESS_MODE AUTO_COMMIT
---------------- ------- --------------- ------------ -----------
41 READ COMMITTED READ/WRITE ON
0 READ COMMITTED READ/WRITE ON
0 READ COMMITTED READ/WRITE ON
ROLLBACK_MODE
--------------
NOT SPECIFIED
NOT SPECIFIED
NOT SPECIFIED
•
Display selected columns of the QUERYCACHEENTRIES table using the same
cached queries:
>>SELECT PLAN_ID, NUM_HITS, IS_PINNED FROM TABLE
(QUERYCACHEENTRIES ());
PLAN_ID NUM_HITS IS_PINNED