I have a query thats performing badly and has a RID lookup. There are already quite a few indexes on the table and in the query stats I can see they are used although some less than others and all are being updated.
My question is should I be looking to create a covering index for the poorly performing index, and when do I add columns as a key and when do I add them as includes?
Also how do I find out which queries are using the other indexes? It would be useful to know which these are such that if I removed them I would want to see if they would use the new covering index instead.
All that said when is it more efficient to have multiple indexes rather than one large covering index containing all the columns of the table.
Thanks in advance as I feel my knowledge has a lot of gaps here.