Query statistics for non-pre-pass queries

Debugging and Troubleshooting

Troubleshooting Resources : Log Entry Types Detail : Query information logging : Query statistics : Query statistics for non-pre-pass queries

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 unique identifier.

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 Databaseblock access.

Table and index read access statistics. See ReadAccess Statistics.

Field list used to optimize the query. See Fieldlist 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 Querypreparation statistics.

For scrolling queries, whether the program used INDEX-REPOSITION on the query.