QueryOperationPerformanceLogIndex

The QueryOperationPerformanceLogIndex compiles information about workers and users interacting with the table.

Since the QueryOperationPerformanceLog is a high-volume internal tables, it has an associated index table that you can use to optimize administrative queries commonly performed against those tables: the QueryOperationPerformanceLogIndex. The Data Import Server produces this Index table as it imports data, making it possible to identify the set of internal partitions that have data for a given key.

Columns

NameDataTypeDescription
DateStringThe date of the event.
InternalPartitionStringThe column used to partition the table.
ProcessInfoIdStringThe unique identifier for the worker, used for correlating log entries and tables.
WorkerNameStringThe worker's name (e.g., worker_6baf6fae).
ServerHostStringThe host that the worker is executing on.
PrimaryAuthenticatedUserStringThe authenticated user that owns the worker.
PrimaryEffectiveUserStringThe effective user that owns the worker.