Reindex SQL Server DB table

DBCC DBReindex(TableName, '', 90)

Or

ALTER INDEX ALL ON TableName REBUILD WITH
(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