June 10, 2012

Command to reindiex,update statistics, database tables in sql through query analyzer

Write this command in query editor then run the command to reindex database

use yourdatabase
dbcc dbreindex('DBNM')

Then use this command to update statistics of database

update statistics 'DBNM'

Command to reindex table


DBCC DBREINDEX(YourTableName, '', 80)

or

DBCC DBREINDEX(YourTableName, '', 70)

No comments:

Post a Comment