© Bradley Beard 2016

Bradley Beard, Practical Maintenance Plans in SQL Server, 10.1007/978-1-4842-1895-2_8

8. Reorganizing Indexes

Bradley Beard

(1)Palm Bay, Florida, USA

Building on what we just did in Chapter 7, we are now going to reorganize our indexes. Is this necessary, since they would have just been rebuilt? Let’s take a look find out.

Reorganizing vs. Rebuilding

Think about a hotel. It’s a nice building, sitting there all built and stuff. It has a structure and multiple floors, with each floor having lots of rooms. You know that you can get right to the room you’re supposed to go to by going into the correct hotel first, and then up the elevator to the floor with the room on it, and then to the actual room. This is exactly how indexing works. ...

Get Practical Maintenance Plans in SQL Server: Automation for the DBA 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.