Regenerate a text index for a table

You can regenerate a table text index when you change table stop words or display values.

Before you begin

Role required: admin

About this task

By default, the system maintains text indexes on a daily schedule. Typically, you only need to manually regenerate a text index when you change these values.

You change the list of table-specific stop words.
You change the display value of a record such as changing a user or group name.

Until you regenerate the index, text searches for old display values will still produce results and searches for the new display value will not show results.

Text indexing can be a resource-intensive task that may take a while to complete. You may notice performance degradation or incomplete search results during index generation. To estimate text indexing duration, you can view historical statistics.

Note: This index regeneration process purges the existing text search index for the table before it regenerates it. While it is processing, no search results are returned if you perform a text search before the regeneration is complete. An alternate method is available that does not impact use of text searches for the table while the regeneration is in process. See Reindex a table text search without impacting returned results.

Procedure

Navigate to System Definition > Text Indexes.
Open the text index for the table.
For example, select task.

The system displays the Text Index record for the table.
Click the Regenerate Text Index related link and click OK.
.

Result

The system schedules the table for text indexing.

Regenerate a text index for a table

You can regenerate a table text index when you change table stop words or display values.

Before you begin

Role required: admin

About this task

By default, the system maintains text indexes on a daily schedule. Typically, you only need to manually regenerate a text index when you change these values.

You change the list of table-specific stop words.
You change the display value of a record such as changing a user or group name.

Until you regenerate the index, text searches for old display values will still produce results and searches for the new display value will not show results.

Procedure

Navigate to System Definition > Text Indexes.
Open the text index for the table.
For example, select task.

The system displays the Text Index record for the table.
Click the Regenerate Text Index related link and click OK.
.

Result

The system schedules the table for text indexing.

How search works:

Topics are ranked in search results by how closely they match your search terms

Regenerate a text index for a table

Regenerate a text index for a table

On this page

Regenerate a text index for a table

Regenerate a text index for a table

Log in to personalize your search results and subscribe to topics