SQL Server Performance

showcontig

Discussion in 'Performance Tuning for DBAs' started by shyam_k25, Jul 21, 2005.

  1. shyam_k25 New Member

    Hi All!

    after DBCC INDEXDEFRAG command and UPDATE STATISTICS.

    when i execute command DBCC showcontig then
    for some tables Best and Actual Count are not same.

    Scan Density [Best Count:Actual Count].......: 50.00% [1:2]

    what should i do to sort the issue?


    Thanks
    Shyam Koti

    Do what you want, Be who you are, Say what you feel, because those who mind
    don't matter and those who matter, don't mind
  2. FrankKalis Moderator

Share This Page