Try OpenEdge Now
skip to main content
Debugging and Troubleshooting
Troubleshooting Resources : Log Entry Types Detail : Query information logging : Query statistics : Query statistics for non-pre-pass queries
 
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 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.