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 ...
Get Microsoft SQL Server 2012 Performance Tuning Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
