- 1). Click the Windows "Start" button on your SQL Server 2000 computer, and select "All Programs." Click "Microsoft SQL Server," then click the "Enterprise Manager" shortcut, which is the 2000 database editing software.
- 2). Right-click the database that contains the tables you want to re-index, and select "Query Analyzer." Another application opens where you can type your re-index code.
- 3). Type the following command in Query Analyzer to re-index a table:
DBCC DBREINDEX ('customers', index_name, 80)
Replace "customers" with the table name you want to re-index. Change "index_name" to your own index name on the table. - 4). Click "Run" in Query Analyzer to run the re-index code. It may take several minutes to complete the indexing of the table. When the process completes, Query Analyzer returns a "Success" message.
previous post