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.
This method does not purge the entire text search index before
the rebuild takes place. It rebuilds the text search table index one record at a time, and
reindexes the target table hierarchy only. For example, if you select the sc_cat_item table, only
the sc_cat_item table is reindexed.
-
Navigate to .
-
In Run script box, type the following syntax for the background
script:
new GlideTextIndexEvent ( ).indexUpdate(tableName, emailAddress);
For example, to regenerate the kb_knowledge table text search index, and specify that
no email notification is required after the rebuild completes, create the following background
script:
new GlideTextIndexEvent ( ).indexUpdate('kb_knowledge', null);
The
script creates an event that the index handler processes so the script completes almost
instantly.
-
Click the Run script button.
The system reindexes the text search for the specified table. For large files, such
as sys_metadata, reindexing can take a couple of hours, but you can still perform text searches
on the table while the script is running.