Product documentation Docs
    • English
    • Deutsch
    • 日本語
    • 한국어
    • Français
  • More Sites
    • Now Community
    • Developer Site
    • Knowledge Base
    • Product Information
    • ServiceNow.com
    • Training
    • Customer Success Center
    • ServiceNow Support Videos
  • Log in

Product documentation

  • Home
How search works:
  • Punctuation and capital letters are ignored
  • Special characters like underscores (_) are removed
  • Known synonyms are applied
  • The most relevant topics (based on weighting and matching to search terms) are listed first in search results
Topics are ranked in search results by how closely they match your search terms
  • A match on the entire phrase you typed
  • A match on part of the phrase you typed
  • A match on ALL of the terms in the phrase you typed
  • A match on ANY of the terms in the phrase you typed

Note: Matches in titles are always highly ranked.

  • Release version
    Table of Contents
    • Now Platform administration
Table of Contents
Choose your release version
    Home Orlando Now Platform Administration Now Platform administration Search administration Zing text indexing and search engine Zing indexes words Regenerate a text index for a table Reindex a table without impacting text search results

    Reindex a table without impacting text search results

    • Save as PDF Selected topic Topic & subtopics All topics in contents
    • Unsubscribe Log in to subscribe to topics and get notified when content changes.
    • Share this page

    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.

    About this task

    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.

    Procedure

    1. Navigate to System Definition > Scripts - Background.
    2. In Run script box, type the following syntax for the background script:
      new GlideTextIndexEvent ( ).indexUpdate(tableName, emailAddress);
      
      Where:
      • tableName is the name of the table you want to reindex.
        Note: Only the specified table and its child tables are reindexed.
      • emailAddress is the address to which an email notification should be sent when the table reindex completes. Type null for no email notification.
      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.

    3. 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.

    Tags:

    Feedback
    On this page

    Previous topic

    Next topic

    • Contact Us
    • Careers
    • Terms of Use
    • Privacy Statement
    • Sitemap
    • © ServiceNow. All rights reserved.

    Release version
    Choose your release version

      Reindex a table without impacting text search results

      • Save as PDF Selected topic Topic & subtopics All topics in contents
      • Unsubscribe Log in to subscribe to topics and get notified when content changes.
      • Share this page

      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.

      About this task

      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.

      Procedure

      1. Navigate to System Definition > Scripts - Background.
      2. In Run script box, type the following syntax for the background script:
        new GlideTextIndexEvent ( ).indexUpdate(tableName, emailAddress);
        
        Where:
        • tableName is the name of the table you want to reindex.
          Note: Only the specified table and its child tables are reindexed.
        • emailAddress is the address to which an email notification should be sent when the table reindex completes. Type null for no email notification.
        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.

      3. 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.

      Tags:

      Feedback

          Share this page

          Got it! Feel free to add a comment
          To share your product suggestions, visit the Idea Portal.
          Please let us know how to improve this content

          Check any that apply

          To share your product suggestions, visit the Idea Portal.
          Confirm

          We were unable to find "Coaching" in Jakarta. Would you like to search instead?

          No Yes
          • Contact Us
          • Careers
          • Terms of Use
          • Privacy Statement
          • Sitemap
          • © ServiceNow. All rights reserved.

          Subscribe Subscribed Unsubscribe Last updated: Tags: January February March April May June July August September October November December No Results Found Versions Search preferences successfully updated My release version successfully updated My release version successfully deleted An error has occurred. Please try again later. You have been unsubscribed from all topics. You are now subscribed to and will receive notifications if any changes are made to this page. You have been unsubscribed from this content Thank you for your feedback. Form temporarily unavailable. Please try again or contact  docfeedback@servicenow.com  to submit your comments. The topic you requested does not exist in the release. You were redirected to a related topic instead. The available release versions for this topic are listed There is no specific version for this documentation. Explore products Click to go to the page. Release notes and upgrades Click to open the dropdown menu. Delete Remove No selected version Reset This field is required You are already subscribed to this topic Attach screenshot The file you uploaded exceeds the allowed file size of 20MB. Please try again with a smaller file. Please complete the reCAPTCHA step to attach a screenshot
          Log in to personalize your search results and subscribe to topics
          No, thanks Login