Analyze Index

Table of Contents

Overview
Analyze index is used to evaluate an indexes physical properties.

Example
round-pushpin Analyzes the index IX_Translation on the Translation schema.
ANALYZE INDEX IX_TargetWordId ON WordList:Synonym

Exmaple output

Schema : Synonym
Name : IX_TargetWordId
Partitions : 1000
Id : 507c3ca8-4383-4067-94bf-8030f66d9236
Unique : False
Created : 8/30/2023 3:39:01 AM
Modified : 8/30/2023 3:39:01 AM
Disk Path : D:\Katzebase\Root\WordList\Synonym\@Index_IX_TargetWordId
Pages Size : 41,760.20k
Disk Size : 27,732.18k
Compression Ratio : 66.41
Root Node Count : 4,245,847
Node Level Count : 1
Min. Node Density : 1
Max. Node Density : 167
Avg. Node Density : 22.02
Document Count : 4,245,847
Selectivity Score : 99.9995%
Attributes {
targetwordid
}

Related