O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

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

Managing Indexes with SSMS

So far, you’ve seen the commands necessary for index management. In addition to these commands, SSMS provides tools for managing indexes.

To reorganize or rebuild an index using SSMS, in the Object Explorer, connect to an instance of the SQL Server 2012 Database Engine and then expand that instance. Then expand Databases, expand the database that contains the table with the specified index, and expand Tables. Next, expand the table in which the index belongs and then expand Indexes. Finally, right-click the index to rebuild and then click Rebuild or Reorganize. To rebuild or reorganize all indexes on a table, right-click Indexes and select Rebuild All or Reorganize All.

You can also disable indexes in SSMS. In the Object ...

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