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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-02 : 07:16:39
|
| Jeet writes "Hi, This is Biswajit. My question is as follows.While running DBCC Showcontig command I found that for one of my table the Scan Density is very less which should be nearing 100%.DBCC SHOWCONTIG scanning 'Attachment' table...Table: 'Attachment' (5575058); index ID: 1, database ID: 7TABLE level scan performed.- Pages Scanned................................: 2- Extents Scanned..............................: 2- Extent Switches..............................: 1- Avg. Pages per Extent........................: 1.0- Scan Density [Best Count:Actual Count].......: 50.00% [1:2]- Logical Scan Fragmentation ..................: 50.00%- Extent Scan Fragmentation ...................: 0.00%- Avg. Bytes Free per Page.....................: 2180.0- Avg. Page Density (full).....................: 73.07%I ran the DBCC DBREIndex command and then I checked it once again. But the same i result I got. Can anybody give a tip how to increase the Scan Density?Note:It is having a primary key." |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-02 : 08:46:29
|
| drop and recreate the primary key.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
Improving Scan density