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

Query Plan Caching
HP NonStop SQL/MX Query Guide—523728-003
6-15
Reviewing the Query Plan Caching Statistics With
the DISPLAY_QC and DISPLAY_QC_ENTRIES
Reviewing the Query Plan Caching Statistics With the
DISPLAY_QC and DISPLAY_QC_ENTRIES Commands
The DISPLAY_QC and DISPLAY_QC_ENTRIES commands provide a quick look at
the most commonly accessed columns of the query plan caching statistics. The
commands are entered at the MXCI prompt with no parameters. If no query plans have
been cached, no rows are returned.
DISPLAY_QC Command
The DISPLAY_QC command accesses the information in the QUERYCACHE function
and displays these columns:
>>DISPLAY_QC;
AVGSIZE CURSIZE MAXSIZE NPINNED NRECOM NRETR NCACHE NHITS
------- -------- -------- -------- -------- -------- -------- --------
31 35 1024 0 0 0 1 0
--- SQL operation complete.
Column Name Type Source column in QUERYCACHE Function
AVGSIZE CHAR(8) AVG_PLAN_SIZE
CURSIZE CHAR(8) CURRENT_SIZE
MAXSIZE CHAR(8) MAX_CACHE_SIZE
NPINNED CHAR(8) NUM_PINNED
NRECOM CHAR(8) NUM_RECOMPILES
NRETR CHAR(8) NUM_RETRIES
NCACHE CHAR(8) NUM_CACHEABLE_PARSING +
NUM_CACHEABLE_BINDING
NHITS CHAR(8) NUM_CACHE_HITS_PARSING +
NUM_CACHE_HITS_BINDING