I have a table with nearly 18 million records and it has nearly 14 indexes including a clustered index.
One of the non-clustered index has a fragmentation level of 97%, so when I tried to rebuild the index - fragmentation level goes down to 96% or 94%. But, it is not reducing any further. Few details about the index,
Key columns: 2 (Includes clustered index column)
- Col 1 - nvarchar(255) – Clustered index column
- Col 2 - nchar(16)
Included columns: 2
- Col 1 - smallint
- Col 2 - smallint
Pages: 143539
Index size: 1.3 GB
Fill factor: 90
Row locks: True
Page locks: False
Pad index: False
Any ideas why fragmentation level is not reducing?