Shulou(Shulou.com)06/01 Report--

For the index of a table, if the index size of the table is very large, it is recommended that the index of the table be re-indexed separately.

Re-index the entire table:

Alter index all on Table rebuild with (online=on)

Re-index only one index on the table:

ALTER INDEX [Index_name] ON [dbo]. [Table] REBUILD with (online=on)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.