Maintain the index of a table in SQL Server

-- Step 1: Check whether maintenance is required and whether the Scan Density/Scan Density is 100%
Declare @ table_id int
Set @ table_id = object_id ('Table name ')
Dbcc showcontig (@ table_id)
-- Step 2: reconstruct the table index
Dbcc dbreindex ('Table name', pk_index name, 100)
-- Redo the first step. If the Scan Density/Scan Density is less than 100%, rebuild all the indexes in the table.
-- Yang Jing: not necessarily 100%.
Dbcc dbreindex ('Table name', '', 100)