LOCALEXECUTIONSTATS System Table Description
Description
A pseudo table that presents aggregate execution statistics for the Transaction Engine (TE) to which the client is connected. This is used for internal performance analysis.
Fields
| Field | Type | Description |
|---|---|---|
COMPILATIONTIME |
bigint |
The total compilation time, in microseconds, for all queries executed by this TE. |
EXECUTIONTIME |
bigint |
The total execution time, in microseconds, for all queries executed by this TE. |
REOPTIMIZATIONCOUNT |
bigint |
The total number of query reoptimzations that have been performed by this TE. |