Rebuilding tables indexes
Hello all,
I have a table that I've just ran DBCC SHOWCONTIG ('Containers') against,
the scan density is coming out as 20% which I understand is bad, as it should
be above 75%, now ran DBREINDEX and also dropped and rebuilt all 4 indexes,
re ran the above and it's still coming out at 20%. Why is that and how do i
fix it?
Also, all columns (5) are of type 'int'.
Thanks,
Jon
|