Normally, after I use DBCC DBREINDEX, I can be sure that Scan Density on a clustered or non-clustered index is very good - eg. 99% or 100%. However, I have one database where there are a number of indexes that are not showing any improvement in Scan Density after running DBCC DBREINDEX. In on case, a clustered index, I run it on two days in succession and Scan Density actually go worse! Can anyone give me a reason for this? Can anyone suggest how to fix it?
CliveI think I found the problem. Look like a newly modified maintenance proc wasn't doing what it should have been.
Clive
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment