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.

Was this article helpful?