Query Number of Rows Estimate

 
Snapshot Level
Application
DCS Statement

 
Logical Data Grouping
stmt
dcs_stmt

 
Monitor Switch
Statement
Statement

Resettable

No

Element Name
Element Type

query_card_estimate
information

Description:  An estimate of the number of rows that will be returned by a query.

Usage:  This estimate by the SQL compiler can be compared with the run time actuals.

This data element also returns information for the following SQL statements when you are monitoring DB2 Connect.

• INSERT, UPDATE, and DELETE

  Indicates the number of rows affected.

• PREPARE

  Estimate of the number of rows that will be returned. Only collected if the DRDA server is DB2 Universal Database, DB2 for VM and VSE, or DB2 for OS/400.

• FETCH

  Set to the number of rows fetched. Only collected if the DRDA server is DB2 for OS/400.

If information is not collected for a DRDA server, then the data element is set to zero.