Modernize index maintenance with Resumable Online Index Rebuild

added by DotNetKicks
3/19/2018 8:19:24 PM

1 Kicks, 278 Views

As we know, the index is one of the most powerful tools for optimizing database performance. As you insert, update, and delete rows, indexes become more fragmented and less effective. Because of this, DBAs regularly do index rebuild operations. With the growing sizes of databases, index rebuilds can take a very long time.