exec sp_MSforeachtable 'dbcc dbreindex (''?'', '''', 90)'
To reindex all tables in a database with higher or lower fill factor.
run:
exec sp_MSforeachtable @command1='DBCC DBREINDEX(''?'') '
This will reindex all the tables with the fillfactor it orginally was set to. Sometime you can test with different fill factors to get higher performance.
No comments:
Post a Comment