First of all, you need to find what indexes need to be rebuild. It not necessary you need to rebuild all indexes on the table. You can rebuild only indexes for which fragmentation is 30% or above.
You can use the below script for the same.
http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html
If you feel, there is a performance degradation or it takes long time, you may need to update the stats for those index and then rebuild. It will support parallel processing in your index rebuild.
Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.
No comments:
Post a Comment