Reputation: 799

How to rebuild index in a specific table columns?

How to rebuild index in a specific table columns with query? in SQL Server 2008

Upvotes: 2

Answers (3)

Narnian

Reputation: 3908

Open the table in the Object Explorer so you see the "Indexes" folder. Right click on the "Indexes" folder and click "Rebuild All". Alternatively, you can open the Indexes Folder and rebuild an individual index.

If you don't have a plan for identifying and rebuilding all your fragmented indexes, you can take a look at the following post:

http://www.foliotek.com/devblog/sql-server-optimization-with-index-rebuilding/

This will take you through looking at a couple of reports before and after your index rebuilding.

Upvotes: 1

Optillect Team

Reputation: 1747

E.g. (read manual)

ALTER INDEX [index_name] ON [dbo].[MyTable] REBUILD WITH (FILLFACTOR = 80, STATISTICS_NORECOMPUTE = ON);

Upvotes: 3

Steve Prentice

Reputation: 23514

One way is to drop the index and recreate it.

Upvotes: 0

How to rebuild index in a specific table columns?

Answers (3)

Related Questions