How to find the columns which are least used for global search in database index of table

[sunil maddheshi]

• 

   

  Hello everyone 

I have a query regarding database index of a CMDB table, How can I find the columns or fields from the database index which are least used for global search and how can I disable them so that performance can be improved, as of now there are lot of text_index events are getting generated which causing to performance issue.(Screenshot)

Any help will be grateful.

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.