Query regarding database index in ServiceNow

[sunil maddheshi]

Hello everyone 

I have a CMDB table on which there are around 200 database index, i need to know which columns or fields are least used for global search, and how to disable them , because it is creating lot of text_index events which is causing to performance issue.

Please advise some suggestion 🙏 

Thanks 

 

[Sandeep Rajput]

@sunil maddheshi I doubt if such information can be extracted unless there is a user experience analytics involved to check which columns were frequently used by the user to search the records.