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 |
|
BabylonMike
Starting Member
1 Post |
 Posted - 2007-06-24 : 18:17:02
|
| HiWhen I run sys.dm_db_index_physical_stats on AdventureWorks.Production.Product, I get an average fragmentaion of 46%, 0%, 25% & 50% on the Indexes.I run ALTER INDEX ALL ON AdventureWorks.Production.ProductREBUILD WITH (FILLFACTOR = 80, SORT_IN_TEMPDB = ON, STATISTICS_NORECOMPUTE = ON)and the index fragmentation does not change...Why is that?? I have tried refreshing the table and the statistics but why does it look like rebuilding the indexes has done nothing? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-24 : 18:26:47
|
| How big are those tables? Sql stores small tables in shared extents, can't do much on them. |
 |
|
|
|
|
|
Index Fragmentation