Regenerate a text index for a table

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

Avant de commencer

The table that you want to regenerate the text index for must already be configured for indexing and searching. For details on this configuration process, see Configure a table for indexing and searching.

Role required: ts_admin or admin

Pourquoi et quand exécuter cette tâche

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 won't show results.

You can also regenerate a text index if you observe incorrect search results for the indexed table. This is rare and usually only occurs if text indexing was interrupted.

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.

Remarque :

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

Procédure

1. Navigate to All > 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. Select the Regenerate Text Index related link, then select OK.

   

Résultats

The system schedules the selected table for text indexing.

• Reindex a table without impacting text search results
  Rebuild text search indexes without adversely impacting search results. You can continue to perform text searches on a table while the index regeneration takes place.
• Regenerate the text index for a single record
  Update the text search index for a single record. Use this approach to quickly verify whether text indexing is the cause of a search issue without rebuilding the full text index for an entire table.

Concepts associés

• Zing indexes punctuation as part of some words
• Zing indexes some HTML elements

Tâches associées

• Configure a table for indexing and searching
• Configure a text index group to search across multiple tables
• Remove an index
• Remove an index for a specific field
• Remove the text index for a child table
• Change the query mode of an indexed table
• Enable indexing of text in multi-row variable sets
• Configure tables to use the Japanese tokenizer

Référence associée

• Zing index and search dictionary attributes
• Text indexing statistics and status