Thread SQL Counts 3 Workspace

The Thread SQL Counts 3 workspace provides information about multi-row processing and concentrate statements.

This workspace is comprised of the following views:

Thread ID (table view)

Lists the thread IDs.

Multi-Row Processing

Enables you to track performance improvements such as multi-row fetch and multi-row insert.

Concentrate Statements

Indicates if literal constants, which are referenced in dynamic SQL statements, are replaced with special markers so that these constants are not cached with the statement in the dynamic SQL statement cache.

Based on the information that this workspace provides, you can recommend changes, set up situations, and verify that your recommended changes improve system performance.