Thank you for your feedback.
Form temporarily unavailable. Please try again or contact to submit your comments.

Regenerate a text index for a table

Log in to subscribe to topics and get notified when content changes.

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.


  1. Navigate to System Definition > Text Indexes.
  2. Open the text index for the table.
    For example, select task.
    The system displays the Text Index record for the table.
  3. Click the Regenerate Text Index related link and click OK.
    Regenerate a text index


The system schedules the table for text indexing.