MasterFile DocumentationHow Tos ArticlesHow do I recreate a corrupted database index?

How do I recreate a corrupted database index?

Occasionally a database index can get corrupted and prevent searching. In this case, the index needs to be deleted and then recreated.

Using the Notes database properties box to delete the database index

The Notes properties box is context sensitive and displays information about the currently selected object.

Right click on the Workspace and choose Workspace Properties.

Using the Notes database properties box to delete the database index

The Notes properties box is displayed and shows information about the Workspace itself.

Depress the database icon and the properties box changes to show information about it. You can also right click on a database icon directly and choose Application > Properties to display its information.

The properties box is persistent and remains visible until you close it. It always displays information about the currently selected object -- for example, if you depress a different database icon, it will change to show details about that database.

  1. Click on the magnifying glass / Search tab and the properties box changes to indexing options.
  2. Click on Delete Index to delete the existing index.

Answer Yes.

Recreating the database index

The property box will now state the Database is not full text indexed.

Click on Create Index ...

Recreating the database index

And the Create Index dialog is shown. Select the option highlighted and click OK.

The status bar will update when indexing is complete. Indexing can take a while on large databases that are many gb in size -- even an hour or more.

You can also use the database properties box to check indexing status.

Click on Count unindexed documents. The count shows one unindexed document remains. A few seconds later, click again and the count shows All are indexed.

Remember, server database indexes are updated periodically while local databases must be updated manually.