INDEXDEFRAG doesn't work | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

INDEXDEFRAG doesn’t work

I have indexes cannot be defraged. After I ran this command, I still get
scandesity = 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.

Or your are looking table itself, no indexs (id 0). First information from showcontig is table.
Luis Martin
Moderator All postings are provided “AS IS” with no warranties for accuracy.