Link to home
Create AccountLog in
Avatar of Vijay
Vijay

asked on

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.
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

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).
and amongst Ola's wonderful work are scripts to monitor the indexes so you minimize these major rebuild events :)

no points please
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!
Avatar of Vijay
Vijay

ASKER

Is it necessary recompile all Stored Procedures after index rebuild/reoranize?
ASKER CERTIFIED SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Vijay

ASKER

Good information.