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 |
|
jung1975
Aged Yak Warrior
503 Posts |
 Posted - 2006-11-15 : 09:54:51
|
| After I ran DBCC SHOWCONTIG , I notice that there is 80% of index fragmentation..so i drop the index in the table and rebuit the index..but it still showing as 80% fragmentation..I even updated the statistic but nothing got changed.It's a clustered index and there are 130000 recordsI am not sure why? and how can I fix this problem? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-11-15 : 10:01:36
|
what is your fill factor?Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
 |
|
|
jung1975
Aged Yak Warrior
503 Posts |
Posted - 2006-11-15 : 10:13:08
|
| actualy, I haven't set up the fill factor yet.. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-11-15 : 11:17:07
|
| It would help if you posted the DBCC SHOWCONTIG output.CODO ERGO SUM |
|
|
|
jung1975
Aged Yak Warrior
503 Posts |
Posted - 2006-11-15 : 11:40:51
|
| DBCC SHOWCONTIG scanning 'Conformed_D_Date' table...Table: 'Conformed_D_Date' (789577851); index ID: 1, database ID: 16TABLE level scan performed.- Pages Scanned................................: 5- Extents Scanned..............................: 5- Extent Switches..............................: 4- Avg. Pages per Extent........................: 1.0- Scan Density [Best Count:Actual Count].......: 20.00% [1:5]- Logical Scan Fragmentation ..................: 80.00%- Extent Scan Fragmentation ...................: 60.00%- Avg. Bytes Free per Page.....................: 1340.0- Avg. Page Density (full).....................: 83.44%DBCC execution completed. If DBCC printed error messages, contact your system administrator. |
|
|
|
Moinul
Starting Member
1 Post |
|
|
|
|
|
index fragmentation