SQL/MX 3.2 Query Guide (H06.25+, J06.14+)

Query Plan Caching
HP NonStop SQL/MX Release 3.2 Query Guide—663851-002
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
TP663851.fm Page 16 Thursday, August 2, 2012 4:47 PM