SQL Server Performance Forum – Threads Archive
INDEXDEFRAG doesn’t workI 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.
DBA, Oxfam GB
Or your are looking table itself, no indexs (id 0). First information from showcontig is table.
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.