Ali Saad
asked on
avg_fragmentation_in_percent not changed after Alter Index
I have strange problem
I execute
ALTER INDEX IX_MyTable ON dbo.MyTable REBUILD
---
When i query from sys.dm_db_index_physical_s tats
i found avg_fragmentation_in_perce nt same not changed
name table_name index_id index_type_desc avg_fragmentation_in_perce nt
IX_MyTable dbo.MyTable CLUSTERED INDEX 66.6666666666667
I even execute
ALTER INDEX ALL ON dbo.MyTable
REBUILD WITH (FILLFACTOR = 80, SORT_IN_TEMPDB = ON,
STATISTICS_NORECOMPUTE = ON);
Nothing happen !!!
What does it means and how to solve this issue to make a de-fragmentation ??
Note: I am using SQL server 2012
I execute
ALTER INDEX IX_MyTable ON dbo.MyTable REBUILD
---
When i query from sys.dm_db_index_physical_s
i found avg_fragmentation_in_perce
name table_name index_id index_type_desc avg_fragmentation_in_perce
IX_MyTable dbo.MyTable CLUSTERED INDEX 66.6666666666667
I even execute
ALTER INDEX ALL ON dbo.MyTable
REBUILD WITH (FILLFACTOR = 80, SORT_IN_TEMPDB = ON,
STATISTICS_NORECOMPUTE = ON);
Nothing happen !!!
What does it means and how to solve this issue to make a de-fragmentation ??
Note: I am using SQL server 2012
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.