striker-baba (4/23/2010)

---

Thanks to all for the replies.

I ran the query

SELECT

a.index_id,

name,

avg_fragmentation_in_percent

FROM sys.dm_db_index_physical_stats (DB_ID(' dbname '),OBJECT_ID(' table a '),NULL, NULL, 'limited') AS a

JOIN sys.indexes AS b ON

a.object_id = b.object_id AND

a.index_id = b.index_id;

and I have 5 indexes on my table

and all 3 indexes are 96% fragmented and 2 of them are 66% fragmented.

I am planning to archive the data and rebuild the indexes on that table.

DO you guys think this will work out .... or Any suggestions.