O'Reilly logo

Microsoft SQL Server 2012 Performance Tuning Cookbook by Bihag Thaker, Ritesh Shah

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Enhance index efficiency by using the REBUILD index

Rebuilding an index will do nothing, but just drop the current index and recreate it internally, so that all fragmentations go away, statistics are updated, and physical sorting order in data pages are in co-ordination with each other. It compacts data pages, fills them up with a proper Fill Factor, and adds new data pages if needed. All these things will help in faster data retrieval, but at the same time this is a really very resource-centric job and takes a very long time to finish on large tables with millions of rows.

Getting ready

Decide first whether it is really necessary to rebuild an Index. If it is worth rebuilding an index, only then should one go for this option. Otherwise, use the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required