Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Reindex Question

Author  Topic 

judes
Starting Member

3 Posts

Posted - 2007-09-28 : 15:53:49
I don't understand why this table does not go to 100% Scan Density after either a DBCC Reindex or DBCC Indexdefrag. Can someone help me understand?

DBCC SHOWCONTIG scanning 'wf_wftrn_tbl' table...
Table: 'wf_wftrn_tbl' (463913320); index ID: 1, database ID: 18
TABLE level scan performed.
- Pages Scanned................................: 8
- Extents Scanned..............................: 2
- Extent Switches..............................: 1
- Avg. Pages per Extent........................: 4.0
- Scan Density [Best Count:Actual Count].......: 50.00% [1:2]
- Logical Scan Fragmentation ..................: 0.00%
- Extent Scan Fragmentation ...................: 50.00%
- Avg. Bytes Free per Page.....................: 2215.4
- Avg. Page Density (full).....................: 72.63%

Kristen
Test

22859 Posts

Posted - 2007-09-28 : 15:56:44
Too few pages. Reindex to improve Scan Density is only going to make an impact for a table quite a bit larger than this one

Kristen
Go to Top of Page

Frank Kalis
Constraint Violating Yak Guru

413 Posts

Posted - 2007-09-28 : 15:59:20
This might also help understanding: http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.de
Heute schon gebloggt? http://www.insidesql.de/blogs
Go to Top of Page

judes
Starting Member

3 Posts

Posted - 2007-09-28 : 16:05:27
Kristen & Frank,
Thanx!

Effect of reindexing a database that is doing transactional replication? Should Replication be stopped 1st?
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-28 : 22:39:55
Don't have to stop replication.
Go to Top of Page

rinov
Starting Member

1 Post

Posted - 2013-03-29 : 11:06:46
Excuse me,
i have a problem with big table,
it is possible that a query does not return data if an index or data file is corrupt?

Thanks
Go to Top of Page
   

- Advertisement -