Link to home
Start Free TrialLog in
Avatar of rwheeler23
rwheeler23Flag for United States of America

asked on

SQL Rebuild Indexes In Masse

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_percent 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

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Hwkranger
Hwkranger
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rwheeler23

ASKER

Both answers were excellent