Hi

The total space of

CREATE INDEX IX_1

ON 123 (A)

INCLUDE (B,C,D)

and

CREATE INDEX IX_2

ON 123 (A)

INCLUDE (E,F,G,H)

will take more space than

CREATE INDEX IX_1

ON 123 (A)

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

The selectivity of each index is same. You don't need two indexes in this case.

My suggestion is to go with the second option, i.e. the index covering all columns (B,C,D,E,F,G,H).

Regards,

Igor