Text Indexing - Recommended Field types to set to no_text_index=trueSummaryOverview This article details recommendation around how Admin/users can best configure their custom tables or ServiceNow out-of-box tables for best performance for search and text indexing. Certain field types may be more or less likely to contain useful search information. Guidelines Things that make a field less likely to be useful in text search behavior include: Fields that contain values that are not the sort of thing that an end-user would be searching for Numeric measurement values with the exception of things like ID's or serial numbers. For example, a field that tracks CPU usage over time would not be a good candidate for text indexing.State process values (e.g. "In Progress", "Pending Change") Fields that are more efficiently searched directly though list filtersFields that contain only a very few possible values or only generic values and thus are not be helpful in narrowing down search resultsFields whose value changes or that are inserted so rapidly it causes excessive processing in the Text Indexing application Dynamic IP AddressesDuration fieldsFields that go back and forth between a few valuesFields that track metric values like size, count, magnitude, usage Text Indexing Behavior by Field Type The following is a list of field types:(See the "Type" field in the "Dictionary" (sys_dictionary) table) Reference: (default: on) The display values of reference fields are indexed. Glide_list: (default: on) Same implications as Reference fields but potentially contain many more values per field and thus have a potentially larger impact on performance Choice: (default: on) Choice fields are likely to contain generic or frequently repeated values and thus are unlikely to be useful in text search. However, this is at user discretion since it is possible that these fields may contain useful search terms. Integer: (default: on*) Very unlikely to be helpful for text search. However, this is still at user discretion, since it is possible that users may search on these fields. Timer: (default: on) Glide_date_time (default: on) Glide_date (default: on) due_date (default: on) glide_duration (default: on*) Boolean (default: off) *ServiceNow is setting all duration fields to not be indexable in the Quebec release. Disabling text indexing on a Field The mentioned fields types can be configured to contain the no_text_index=true attribute to prevent indexing when text index generation executes which will help to make searching more performant for users. References [References?]