How to rebuild indexes in SQL Server Database
Andrew Jackson ~
Modified: October 22nd, 2015 ~ ~ 1 Minute Reading
- This topic has 6 replies, 3 voices, and was last updated 9 years, 2 months ago by .
Viewing 7 posts - 1 through 7 (of 7 total)
-
Posts
-
Yes, you can do it by using SQL Server Management Studio or using T-SQL.
Execute the below query
USE AdventureWorks2012; GO ALTER INDEX PK_Employee_BusinessEntityID ON HumanResources.Employee REBUILD; GONo this query is only to rebuild a defragmented index. But you can rebuild all indexes in a table by using the following query
USE AdventureWorks2012; GO ALTER INDEX ALL ON Production.Product REBUILD WITH (FILLFACTOR = 80, SORT_IN_TEMPDB = ON, STATISTICS_NORECOMPUTE = ON); GORebuild all indexes on a table using SQL Server Management Studio
In Object Explorer, connect to Instance Services.. and then expand that instance
Expand Database that contains the table with the specified indexes, then expand Tables
Expand the table in which the indexes belong
Right click on the Indexes and then select Rebuild All and click OK
Viewing 7 posts - 1 through 7 (of 7 total)
- You must be logged in to reply to this topic.