DBCC DBREINDEX
(
table_name
[ , index_name [ , fillfactor ] ]
)
[ WITH NO_INFOMSGS ]
-- Rebuilding an index
DBCC DBREINDEX ("HumanResources.Employee", PK_Employee_BusinessEntityID,80)
-- Rebuilding all indexes (of a table)
DBCC DBREINDEX ("HumanResources.Employee", " ", 70)
No comments:
Post a Comment