INDEX_STATISTICS

This view contains statistics about indexes. Each row displays information about a given index on a given database partition.

Column Name

Description

DATABASE_NAME

The name of the related database.

TABLE_NAME

The name of the related table.

INDEX_NAME

The name of a given index.

ORDINAL

The partition ID number.

HOST

The hostname or IP address of the related node.

PORT

The port number of the related node.

NODE_TYPE

The type of node: master aggregator (MA), child aggregator (CA), or leaf node (LEAF).

PARTITION_TYPE

The type of partition: master or secondary.

MEMORY_USE

The amount of memory, in bytes, used by a given index.

Last modified: December 12, 2023

Was this article helpful?