How to rebuild an index in certain columns of a table?

Question

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

+1

Michael born Jun 15 '11 at 20:42

3 answers

One way is to reset the index and restore it.

0

Steve prentice Jun 15 '11 at 20:45

, "". "" " ". , .

, :

This will allow you to view multiple reports before and after index recovery.

0

Narnian Jun 22 '11 at 19:31

Optillect team · Accepted Answer · 2011-06-15T20:46:23+0000

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