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 the related node: leaf, master aggregator, child aggregator.

PARTITION_TYPE

The type of partition: master or secondary.

MEMORY_USE

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

Last modified: August 29, 2022

Was this article helpful?