question

Hi, I have below 3 indexes on foreign keys in a table with the below stats captured with Brent's sp_blitzIndex. I am trying to figure if they are doing any good or just adding a maintenance overhead. Could you please provide any inputs around this? **Usage Stats** index 1 - Reads: 3,496,036 (3,495,890 seek 146 scan) Writes:36,723,454 index 2 - Reads: 1,926 (1,910 seek 16 scan) Writes:36,723,459 index 3 - Reads: 1,819,529 (1,819,529 seek) Writes:36,723,454 **Op Stats** index 1 - 4,914 singleton lookups; 415,868,223 scans/seeks; 0 deletes; 0 updates; index 2 - 88,419 singleton lookups; 90,106 scans/seeks; 0 deletes; 0 updates; index 3 - 0 singleton lookups; 0 scans/seeks; 0 deletes; 0 updates; **Lock Waits** index 1 - Lock escalation attempts: 318,167; Actual Escalations: 0. index 2 - Lock escalation attempts: 318,155; Actual Escalations: 0. index 3 - Lock escalation attempts: 18,557; Actual Escalations: 0. Regards.