How to find the columns which are least used for global search in database index of table
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-09-2024 11:59 PM
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

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-10-2024 10:44 PM
@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.