I have a 6.5 server that has multiple tables with poor scan density. I did
a dbreindex of the clustered index which rebuilt the clustered index as well
as all non clustered indexes. A subsequent dbcc showcontig shows that the
scan density did not change. I tried the rebuild multiple times and I also
tried a slightly different fill factor all to no avail.
Any ideas would be appreciated.