Home Forums SQL Server 2016 SQL Server 2016 - Administration Index Framentation RE: Index Framentation
jasona.work
SSC Guru
Points: 50082
More actions
February 5, 2018 at 6:49 am
#1978537
Another thing to check is, what is the data type of the key column(s) of the index?
I've got several tables with 90+% fragmentation which I don't even bother with defragmenting, because the key columns (in the clustered index, no less,) are GUIDs.