OpenEdge provides a single set of statistics for non-pre-pass queries at query completion. Query information logging logs the following query statistics when the query is complete:

  • Procedure name and line number where the block ends or where the AVM closes the query.
  • Query ID, the query's identifier.
    Note: A Query ID is used to group all the log entries for a given query between the time the query is open and then closed. The Query ID may remain the same for a given query if it’s opened multiple times, but that is not guaranteed. The Query ID is only guaranteed to be the same while the query is executing..
  • For dynamic or static queries, a string representation of the query handle, and the name of the query object (if available).
  • Database block access required to resolve the query. This is not logged for queries on temp-tables. See Database block access.
  • Table and index read access statistics. See Read access statistics.
  • Field list used to optimize the query. See Field list information.
  • Number of available records for each table in the query. See Number of available records in the query.
  • Number of records for each table in the query that were sent to the client to resolve the query. See Number of records sent by the server.
  • Whether the client rather than the server performs selection of records for each table in the query.
  • For dynamic or static queries, number of times the AVM has opened this query.
  • For dynamically opened queries, query preparation statistics. See Query preparation statistics.
  • For scrolling queries, whether the program used INDEX-REPOSITION on the query.