Description. REINDEX rebuilds an index using the data stored in the index’s table, replacing the old copy of the index. There are several scenarios in which to use REINDEX: An index has become corrupted, and no longer contains valid data.

What is reindex file?

The Reindex option is used to fix corruption and other problems, for example missing records within modules. Reindex writes all of the record information from the relevant module to a new index file and then replaces the original index file with the new one. … Before you reindex your data, take a backup of your data.

How do I reindex a database?

1. In Object Explorer, Expand the database that contains the table on which you want to reorganize an index.
2. Expand the Tables folder.
3. Expand the table on which you want to reorganize an index.
4. Expand the Indexes folder.
5. Right-click the index you want to reorganize and select Rebuild.