DBCC?DBReindex(TableName, '',?90)
Or
ALTER?INDEX?ALL?ON?TableName?REBUILD?WITH
(FILLFACTOR?=?90,?SORT_IN_TEMPDB?=?ON,?STATISTICS_NORECOMPUTE?=?OFF,?ONLINE?=?OFF);
(FILLFACTOR?=?90,?SORT_IN_TEMPDB?=?ON,?STATISTICS_NORECOMPUTE?=?OFF,?ONLINE?=?OFF);
90 Refers to page density 90%, 10% is reserved for update.
?
Show Index result by
DBCC?SHOWCONTIG
