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

Query Plan Caching
HP NonStop SQL/MX Query Guide—523728-003
6-16
Reviewing the Query Plan Caching Statistics With
the DISPLAY_QC and DISPLAY_QC_ENTRIES
DISPLAY_QC_ENTRIES Command
The DISPLAY_QC_ENTRIES command accesses the information in the
QUERYCACHEENTRIES function and displays these columns:
DISPLAY_QC_ENTRIES;
ROWID TEXT NUMHITS PH COMPTIME AVGHTIME
-------- ------------------------------------ -------- - -------- --------
0 select * from job; 0 B 88 0
1 select * from dept; 0 B 115 0
2 select * from employee; 0 B 1605 0
--- SQL operation complete.
Column Name Type
Source column in QUERYCACHEENTRIES
Function
ROWID CHAR(8) ROW_ID
TEXT CHAR(36) TEXT
NUMHITS CHAR(8) NUM_HITS
PH CHAR(1) PHASE
COMPTIME CHAR(8) COMPILATION_TIME
AVGHITTIME CHAR(8) AVERAGE_HIT_TIME