HP Neoview Release 2.5 Software - Manual (Page 24)

Table 3-1 QUERY_STATS_VW2 Field Definitions (continued)
Description Data Type Field Name
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
Estimated total cost (time in seconds) of the
SQL operations for this query in the Master
Executor. The estimate occurs at the time the
query is prepared.
Example: 1.74125E-6 DOUBLE PRECISION
DEFAULT NULL EST_COST
Estimated number of rows that will be
returned. The estimate occurs at the time the
query is prepared.
Example: 10.0 DOUBLE PRECISION
NO DEFAULT EST_CARDINALITY
24 Repository Views