SQL Server Performance Forum – Threads Archive
INDEXDEFRAG doesn’t work
I have indexes cannot be defraged. After I ran this command, I still getscandesity = 33, 50. Maybe because these have only one page each?
yup, scan densities of 50%, 33.3% etc typically indicate the tables are so small that they are being stored on shared extents.
Tom Pullen
DBA, Oxfam GB
Thanks Tom.
-Mingus
Or your are looking table itself, no indexs (id 0). First information from showcontig is table.
Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
]]>