(DQEC0) FIND Statistics

 =>
 Current Dataquery FIND/SELECT Statistics.
 --------------------------------------------------------------------------DQEC0
 DATAQUERY:  FIND STATISTICS                       QUERY NAME: PROGRAMS
 -------------------------------------------------------------------------------
 
 TNM-BID  STRG  Q RELS RELO     I/O   E-I/O  E-ROWS    CARD RQAS      KEY F-BUF
 -------- ----- - ---- ---- ------- ------- ------- ------- ---- -------- -----
 PGM    2   336 N                 5     N/A     N/A     N/A   72
 
 
 
 
 
 
 
 
 
 
 
 -------------------------------------------------------------------------------
 <PF1> HELP        <PF2> RETURN       <PF3> OVERALL STATS

Description

The FIND/SELECT Statistics panel appears when you display query output on your video screen, press <PF6> STATS, or enter the STALL command. When you press <PF3> OVERALL STATS after the FIND Statistics panel (DQEF0) appears, further statistical information about query processing appears on DQEC0.

Action

Note the query statistics if a problem occurs during query execution and be prepared to report the information to your CA Dataquery Administrator for help with problem resolution.

Display Fields

Refer to the following for explanations of the display fields intended to contain variable data.

TNM-BID

Table name and database ID.

STRG

Length of permanent storage for this table, including the request area, RQA size, nonqualifying with list, and overhead. CA Dataquery and the Compound Boolean Selection Facility of CA Datacom/DB dynamically handle the search optimization. CA Dataquery uses predicates (a WITH in a DQL Mode query FIND statement) to build a Compound Boolean Selection Request Qualification Area (RQA), converting the selection criteria in a query's statements into the Compound Boolean Selection format.

NQ

Nonqualifying predicates.

RELS

Related subject, column, key or value.

RELO

Related object, column, or key.

I/O

Number of I/Os for this execution.

E-I/O and E-ROWS

Estimated I/O from Compound Boolean Selection estimate calls for join optimization. E-I/O and E-ROWS apply to a single table. The values are calculated using the E-I/O and E-ROWS values for each table, the relative cardinalities of the tables, whether the related objects are indexed or not, and the number of rows requested in the query. The numbers shown are normally the values received from the Compound Boolean Selection Facility only for the first table listed on DQEC0. The other tables have been adjusted based on relative cardinality, and so forth.

CARD

The number of rows on the table, if joining. The relative cardinality of the tables figures into join optimization.

RQAS

Shows whether a query is nearing the 9999 RQA limitation.

KEY

Means one of two things, depending on whether the name is followed by an R or a G.

R: Indicates that Compound Boolean Selection used this key because it is a related object in the table and the ratio of table cardinalities indicated that the key may optimize the join.
G: Indicates that Compound Boolean Selection suggested using the key if executing in batch and only for the primary table in the search.

F-BUF

Storage used for buffering for nonqualifying predicates or cross-joined WITH statements.

PF Keys

The following lists the PF keys for this panel, with a brief description of each function.

<PF1> HELP: Displays Help information about the current panel.
<PF2> RETURN: Exits panel.
<PF3> OVERALL STATS: Views Query Statistics panel (DQEF0).