I have this database that I would like to tune. I ran this script I found to look at index fragmentation. Most indexes are coming back with avg_fragmentation_in_perce
nt in excess of 70%. Is there any way to reindex all these indexes in one command or do I need to have one script that build a long script full of reindex commands, one per index?
SELECT ps.database_id, ps.OBJECT_ID,ps.index_id, b.name,ps.avg_fragmentation_in_percent
FROM sys.dm_db_index_physical_stats (DB_ID('POWMT'), NULL, NULL, NULL, NULL) AS ps
INNER JOIN sys.indexes AS b ON ps.OBJECT_ID = b.OBJECT_ID
AND ps.index_id = b.index_id
WHERE ps.database_id = DB_ID() and ps.avg_fragmentation_in_percent>10.0
ORDER BY ps.OBJECT_ID