Resolve negative value seen for "Total Terms" in System Definition > Text IndexesSummaryIn System Definition > text Indexes, "Total Terms" show negative value ReleaseAllInstructionsRegenerating text index will not resolve this issue. The Total Terms is expected to stay negative due to the number of records.Related LinksOut of the box job "TS Index Stats" runs daily and updates "Total Terms" column in ts_index_name table. In spite of this job execution, the "total terms" remains negativeThe reason for showing negative value of "Total terms" is due to overflow of the integer. In text index for sys_metadata tables ts_index_39_0 - ts_index_39_9, there are 335,553,667 records in the ts_index_39_0 table and when the platform calculates the total terms, this number is multiplied with number of shard table aka 10 which yields to a big number of 3,355,536,670 and this is larger than the max integer of 2,147,483,647 and causes the overflow (negative number)For more information on "Total Terms" refer to ServiceNow documentation - Home > Now Platform administration > Search administration > Zing text indexing and search engine > Zing indexes words > Text indexing statistics and status. At the time of writing this article, the link to the documenation is https://docs.servicenow.com/bundle/tokyo-platform-administration/page/administer/search-administration/reference/r_ViewTextIndexingStatsAndStatus.html