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.
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: 18TABLE 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 oneKristen |
|
|
Frank Kalis
Constraint Violating Yak Guru
413 Posts |
|
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? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-28 : 22:39:55
|
Don't have to stop replication. |
|
|
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 |
|
|
|
|
|