SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—523725-004
9-116
Examples of QUERYCACHEENTRIES
Examples of QUERYCACHEENTRIES
•
Display all information contained in the QUERYCACHEENTRIES table. Note that
the output has been formatted for readability.
>>SET SCHEMA SAMDBCAT.PERSNL;
--- SQL operation complete.
>SELECT * FROM EMPLOYEE;
Employee/Number First Name Last Name Dept/Num Job/Code Salary
-------------- -------------- -------------- -------- -------- ---------
1 ROGER GREEN 9000 100 175500.00
23 JERRY HOWARD 1000 100 137000.10
29 JANE RAYMOND 3000 100 136000.00
.
.
.
--- 62 row(s) selected.
>SELECT * FROM DEPT;
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