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 - 2002-08-14 : 08:31:55
|
| David writes "Hi,I wonder if you can help me out with something. We have a database (v7) which performs a large number of inserts and deletes during the day and as a consequence the indexes become fragmented very quickly.I have used DBCC REINDEX to rebuild the indexes but when I re-run DBCC SHOWCONTIG against the key tables, the index appears to be as fragmented as before. This is the output from DBCC ShowcontigTABLE level scan performed.- Pages Scanned................................: 13797- Extents Scanned..............................: 2031- Extent Switches..............................: 2030- Avg. Pages per Extent........................: 6.8- Scan Density [Best Count:Actual Count].......: 84.93% [1725:2031]- Extent Scan Fragmentation ...................: 67.50%- Avg. Bytes Free per Page.....................: 6220.3- Avg. Page Density (full).....................: 23.15%DBCC execution completed. If DBCC printed error messages, contact your system administrator.All of the indexes are non-clustered due to the very high levels of inserts, deletes and updates.Any help would be very much appreciated.David" |
|
|
royv
Constraint Violating Yak Guru
455 Posts |
Posted - 2002-08-14 : 08:48:35
|
| DBCC REINDEX does not do anything when the only indexes are non-clustered indexes. Try putting a clustered index on the table. Also, if you have a high level of inserts, deletes and updates, then it is actually beneficial for you to put a clustered index.*************************Someone done told you wrong! |
 |
|
|
|
|
|
DBCC Problem