SQL Server Performance

Scan Density is same after reindexing

Discussion in 'Performance Tuning for DBAs' started by Arman, Feb 27, 2008.

  1. Arman New Member

    Hi All, I want to know that why the dbcc showcontig is giving me the same results after running dbcc reindex. I have sql server 2000 with sp4.
    Thanks
  2. thomas New Member

    How large is the table, how many rows, how many data pages? Small tables are held on shared extents and this means they have scan densities of things like 33.3%, 50%, etc. Reindexing them will make no difference. There is no point reindexing tables unless they have > 1000 pages of data, really.
  3. satya Moderator

Share This Page