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 |
|
debug2k
Starting Member
18 Posts |
 Posted - 2004-05-23 : 17:48:32
|
| Hello frens,here is one interseting puzzle to solve. I have a situation where I have 4 non clustered indexes on a table, which is the main transaction table, the current Scan density the DBCC SHOWCONTIG is showing is 40%, I want to make it 100% by rebuilding the indexs by using DBCC DBREINDEX, but the even after doing a dbcc dbreindex the value does not change and indexes are rebuilt, the Fill Factor settings are default.Please solve this if u can :).Regards,Debug |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-05-24 : 01:22:30
|
| Drop and recreate the indexes. :)MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-05-24 : 06:41:57
|
| BOL also recommends DBCC INDEXDEFRAG as a way to defrag indexes.Raymond |
|
|
|
debug2k
Starting Member
18 Posts |
Posted - 2004-05-24 : 07:52:25
|
| can a absence of a clustered index cause this ?regards,Deepak Uniyal |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-05-24 : 08:23:56
|
| It could. That's yet another reason to have a clustered index on every table. The reindex of the clustered index insures the data is reordered each time.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Scan Density