kimreyj (2/25/2014)

---

After doing some performance research, it appears that covering index(es) may be beneficial for a couple transactional tables in my database.

My question is this:

Is there ever a benefit to create multiple indexes with different nonkey columns when the key columns are the same?

For instance, if I have the following scenario:

For table 123:

Index key column A

nonkey columns B,C,D,E,F,G,H

Would it ever make sense to:

CREATE INDEX IX_1

ON 123 (A)

INCLUDE (B,C,D)

CREATE INDEX IX_2

ON 123 (A)

INCLUDE (E,F,G,H)

vs one:

CREATE INDEX IX_1

ON 123 (A)

INCLUDE (B,C,D,E,F,G,H)

Thanks!