What does "Unique terms" in a text index mean?

[bonsai]

I would like to know the meaning of the numbers set in "Unique terms[unique_terms]" of a text index record.

Are the numbers displayed here the words registered in the text index?

Where can I check this?

[Jitendra Diwak1]

Hi @bonsai,

Please find the below reference:

In ServiceNow, the "Unique terms" in a text index refer to the distinct words or tokens that are stored in the index to facilitate faster text searching.

A text index is used to optimize search operations for large text fields, allowing for more efficient querying and retrieval of records based on keywords. When the system indexes a text field (such as a description or notes field), it analyzes the content and breaks it down into individual terms (words or phrases). The "Unique terms" count represents the number of distinct words that have been indexed.

For example:

• If you have a record with a description like "The system is down and needs repair," the text index will break this down into terms like "system," "down," "needs," and "repair." If the term "system" appears multiple times across different records, it will only be counted once as a unique term in the index.

Having a large number of unique terms typically indicates a diverse set of keywords, while a smaller number might suggest more repetition or fewer distinct words in the indexed text fields.

In summary, "Unique terms" in a text index are the distinct individual words or phrases that have been indexed to support efficient text searching in ServiceNow.

Please accept my resolution if it works for you and thumps up.

Thanks

Jitendra