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

sunil maddheshi
Tera Guru
  • 1000090039.jpg

    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 

1 REPLY 1

Sandeep Rajput
Tera Patron
Tera Patron

@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.