HP Neoview Release 2.5 Software - Manual (Page 93)

Table E-1 QUERY_STATS_VW1 Field Definitions (continued)
Description Data Type Field Name
Indicates whether this query is required to
execute under a transaction. All SQL
statements require a transaction except
SELECT statements that use the READ
UNCOMMITTED isolation level.
Values:
• 1 = True
• 0 = False
INTEGER UNSIGNED
DEFAULT NULL COMPILE_TRANSACTION_NEEDED
Flags queries in which a join has been
specified with no predicates.
Joins with no predicates may result from
predicate movement during optimization or
simply because no predicate was specified
for the join.
Values:
• 1 = True
• 0 = False
INTEGER UNSIGNED
DEFAULT NULL COMPILE_MANDATORY_CROSS_PRODUCT
Indicates whether single column missing
statistics warnings were raised during
compilation (SQLCODE 6008 or 6011).
Values:
• 1 = True
• 0 = False
Multi-column missing statistics warnings
(SQLCODE 6007 or 6010) are not flagged in
this field.
INTEGER UNSIGNED
DEFAULT NULL COMPILE_MISSING_STATS
The number of joins in the query plan. INTEGER UNSIGNED
DEFAULT NULL COMPILE_NUM_JOINS
Indicates whether the query plan will
perform a full scan on at least one table.
Values:
• 1 = True
• 0 = False
INTEGER UNSIGNED
DEFAULT NULL COMPILE_FULL_SCAN_ON_TABLE
The estimated number of rows accessed by
a full scan of a table. Valid only if Full Scan
On Table is set.
If the query plan contains more than one full
scan operation, the largest number of rows
accessed by all scans is reported here.
Values:
• Largest number of rows accessed
• -1.0 – Full Scan on Table is not set.
• Zero (0.0) – A full scan was performed on
an empty table.
DOUBLE PRECISION
DEFAULT NULL COMPILE_ROWS_ACCESSED_FULL_SCAN
Estimated number of rows to be accessed by
all scan, insert, update and delete operations
in the query plan.
Example: 5.0 DOUBLE PRECISION
DEFAULT NULL COMPILE_DISK_PROCESS_ROWS_ACCESSED
Estimated number of rows accessed by scan
and insert operations in the query plan.
Example: 2.0 DOUBLE PRECISION
DEFAULT NULL COMPILE_DISK_PROCESS_ROWS_USED
Query Statistics for R2.4 SP2 93