SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
9-140
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;
PLAN_LENGTH INT Size in bytes of the compiled plan associated with
this entry.
COMPILATION_TIME INT Time in milliseconds it took to compile the query
associated with this entry.
AVERAGE_HIT_TIME INT Time in milliseconds it took on the average to
process a query as a cache hit against this entry.
SHAPE CHAR(1024) Required CONTROL QUERY SHAPE of the query
associated with this entry. Blank if no required
shape.
ISOLATION_LEVEL CHAR(20) Transaction isolation level associated with the
query. Can be READ UNCOMMITTED, READ
COMMITTED, REPEATABLE READ,
SERIALIZABLE, or NOT SPECIFIED.
ISOLATION_LEVEL_F
OR_UPDATES
CHAR (20) Transaction isolation level associated with the
DELETE or UPDATE part of this query (if any) or
with an INSERT statement. Can be
READ_COMMITTED, REPEATABLE READ, or
SERIALIZABLE.
ACCESS_MODE CHAR(20) Transaction access mode value associated with
the query. Can be READ ONLY, READ WRITE, or
NOT SPECIFIED.
AUTO_COMMIT CHAR(15) Transaction autocommit value associated with the
query. Can be ON, OFF, or NOT SPECIFIED.
ROLLBACK_MODE CHAR(15) Transaction rollback mode value associated with
the query. Can be WAITED, NO WAITED, or NOT
SPECIFIED.
Column Name Data Type Description