• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 85
  • Last Modified:

Rebuild Indexes on SQL Server 2016

Hi,

What is the fastest way to rebuild indexes on SQL Server 2016 Ent.? This is standalone server. no other applications are running.

We are planning to rebuild indexes on around 70 DBs, each DB contains 3 tables and each table having billions of rows.
0
Vijay
Asked:
Vijay
1 Solution
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
There's no miracle solution. You'll need to reindex index by index.
I recommend you to download Ola's maintenance script and run it in your SQL Server instance. It will create a reindex job and only thing you have to do is to run the job manually or schedule it to run during no activity period (usually night and weekends).
2
 
PortletPaulfreelancerCommented:
and amongst Ola's wonderful work are scripts to monitor the indexes so you minimize these major rebuild events :)

no points please
0
 
ZberteocCommented:
Absolutely the BEST way, Ola's scripts! The BIG advantage compared with the SQL Maintenance plan is that it will NOT do this fragmentation if it is not necessary! Disclaimer: I am not aware if this was introduced to versions greater than SQL 2012!
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
VijayAuthor Commented:
Is it necessary recompile all Stored Procedures after index rebuild/reoranize?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Is it necessary recompile all Stored Procedures after index rebuild/reoranize?
No.
0
 
VijayAuthor Commented:
Good information.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now