How can I remove text index for certain fields ?

[Community Alums]

Hi Everyone,
I need to remove text index for certain fields in the cmdb_ci_ip_address table, which text index field is already false. Anyone provide solution for this.

Thanks & reagrds 
Venugopal S

@Ankur Bawiskar @Pradeep Sharma @Chuck Tomasi 

[Mike_R · Accepted solution]

https://docs.servicenow.com/bundle/sandiego-platform-administration/page/administer/search-administr...

Procedure

1. Navigate to All > System Definition > Dictionary.
2. Edit the dictionary entry for the table field.
3. In the Attributes related list, select New.
4. On the Dictionary Attribute form, fill in the fields:
   Field Value

   Attribute	No text index
   Value	true

5. Select Submit.
6. Select Update.

[Stefan Reichelt]

Hi,

I have a related question: What if I still see text_index events being generated for that field, even though I set the attribute to true?

Best regards

[Danny Mortensen]

Just a further note on this: The text index field is not applicable at the field level, it only applies at the table level on the collection record. This is similar to the Audit field which applies at the table level.

[Stefan Reichelt]

But the attribute should still work on field level, right?

At least it's even mentioned in a KB article, and I know at least one situation where it was necessary to set it to some custom fields for instance performance reasons.

Text Indexing - Recommended Field types to set to no_text_index=true - Support and Troubleshooting (...