Imagine you got a Items table with 20+ indexes causing a lot of performance issues because of the active transactions load that is happening on that table. How would you go about optimizing this table?
You should be running a SQL query like below to understand the index usage statistics: --
Assuming the result of running the above query shows an output (showing key columns to narrow down the focus) like below:
Which of the indexes would you delete and why?