Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    71

    Unanswered: DBCC DBREINDEX unexpected results

    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?

    Clive

  2. #2
    Join Date
    Nov 2002
    Posts
    71
    I think I found the problem. Look like a newly modified maintenance proc wasn't doing what it should have been.

    Clive

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •