Try OpenEdge Now
skip to main content
Debugging and Troubleshooting
Troubleshooting Resources : Log Entry Types Detail : Query information logging : Query statistics : Query statistics for pre-pass queries
 
Query statistics for pre-pass queries
OpenEdge provides two sets of query statistics for pre-pass queries: first, when the AVM builds the result-list; second, when the query is complete (that is, at the end of the block or when the AVM closes the query).
OpenEdge logs the following query statistics when it completely builds the result-list for a pre-pass query:
*Procedure name and line number where the AVM built the result-list.
*Query ID, the query's unique identifier.
*For static and dynamic queries, a string representation of the query handle, and the name of the query object (if available).
*Number of entries in the result-list.
*Time taken to build the result-list. See Timetaken to build a result-list.
*Database block access required to build the result-list. See Databaseblock access.
*Table and index read access statistics. See ReadAccess Statistics.
*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.
*Field list used to optimize the query. See Fieldlist information.
*Whether the client rather than the server performs selection of records for each table in the query.
*Number of times the AVM has opened this query. A program can reuse static and dynamic query objects. Opening a query multiple times, as within a loop, might indicate poor programming practice.
*For dynamically opened queries, query preparation statistics. See Querypreparation statistics.
OpenEdge logs the following query statistics when the pre-pass query is complete:
*Procedure name and line number where the block ends or the AVM closes the query.
*Query ID, the query's unique identifier.
*For statically and dynamically opened queries, a string representation of the query handle, and the name of the query object (if available).
*Database block access required to retrieve the ABL records. This is not logged for queries on temp-tables. See Databaseblock access.
*Table and index read access statistics. See ReadAccess Statistics.
*Number of available records for each table in the query. See Number of available records in the query.
*Whether the program used INDEX-REPOSITION on the query.