Panels › (DQMI0) Estimated Statistics

(DQMI0) Estimated Statistics

 =>
 
 Estimated statistics have exceeded maximum limits.  To proceed with query:
 press the PF4 key.  To cancel execution of query: press the PF2 key.
 --------------------------------------------------------------------------DQMI0
 DATAQUERY:  ESTIMATED STATISTICS                  QUERY NAME:
 -------------------------------------------------------------------------------
 
              NUMBER REQUESTED:
 
      FIND TERMINATED BECAUSE:
 
                                ESTIMATED
                                ---------
      TOTAL ESTIMATED ROWS:
      TOTAL JOINS EXAMINED:
      VALID JOINS EXAMINED:
      TOTAL ESTIMATED I/O
 
 
 
 
 -------------------------------------------------------------------------------
 <PF1> HELP     <PF2> RETURN      <PF3> NOT USED    <PF4> CONTINUE

Description

This DQL Mode panel displays estimated information about the execution of the active query's FIND statement. If estimated I/O exceeds the system option or user option maximum, the query will not be executed unless you press <PF4> CONTINUE.

Action

Decide whether to continue or cancel execution of the query.

Display Fields

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

QUERY NAME:

Query being executed.

NUMBER REQUESTED:

All or the number of rows requested in the query.

FIND TERMINATED BECAUSE:

Total estimated I/O exceeds estimated MAX I/O.

TOTAL ESTIMATED ROWS:

Estimated number of rows expected in the output.

TOTAL JOINS EXAMINED:

Number of joins created by the query and examined by this program.

VALID JOINS EXAMINED:

Number of valid joins examined.

TOTAL ESTIMATED I/O

Estimated number of CA Datacom/DB physical I/O events for the processing of the FIND statement.

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 the current panel and cancels execution.

<PF4> CONTINUE

Continues query execution.