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 2008 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 ...
Get Microsoft® SQL Server 2008 R2 Unleashed 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.
