When any data modification operations (INSERT, UPDATE, or DELETE statements) table fragmentation can occur. DBCC DBREINDEX statement can be used to rebuild all the indexes on all the tables in database. DBCC DBREINDEX is efficient over dropping and recreating indexes.
DBCC
Execution of Stored Procedure sp_updatestats at the end of the Indexes process ensures updating stats of the database.
DBREINDEX ('TestTable', ' ',80)
DBCC
Execution of Stored Procedure sp_updatestats at the end of the Indexes process ensures updating stats of the database.
DBREINDEX ('TestTable', ' ',80)
Comments
Post a Comment