SQL/MX 2.x Reference Manual (H06.04+)

MXCI Commands

HP NonStop SQL/MX Reference Manual—540440-003

4-20

DISPLAY_QC_ENTRIES Command

Considerations for DISPLAY_QC_ENTRIES

Examples of DISPLAY_QC_ENTRIES

The DISPLAY_QC_ENTRIES command generates and displays selected data from the

result of the QUERYCACHEENTRIES function. For a description of the result table of

the QUERYCACHEENTRIES function, see the QUERYCACHEENTRIES Function on

page 9-112.

You can use DISPLAY_QC_ENTRIES only within an MXCI session.

Considerations for DISPLAY_QC_ENTRIES

Using QUERYCACHEENTRIES and DISPLAY_QC_ENTRIES

The DISPLAY_QC_ENTRIES command provides a shortcut display of the most

commonly used columns of the QUERYCACHEENTRIES function.

Purpose of the QUERYCACHEENTRIES Function Result

The query plan cache automatically collects statistics on each entry of the cache.

When invoked, the QUERYCACHEENTRIES table-valued function collects and returns

these statistics in a table with one row for each entry of the cache. The statistics are

reinitialized when an mxcmp session is started. Each mxcmp session maintains an

independent set of statistics.

Result of the DISPLAY_QC_ENTRIES Command

The DISPLAY_QC_ENTRIES command displays these selected columns from the

QUERYCACHEENTRIES function:

Note that some of the fields can take on the value OVERFLOW if the cache statistics

value is too large. In addition, the TEXT field can be truncated with only the first 36

characters displayed.

DISPLAY_QC_ENTRIES

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