O'Reilly logo

Practical Maintenance Plans in SQL Server: Automation for the DBA by Bradley Beard

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

© 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. ...

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