I have two indexes that index the same field on the same table. The only difference between them is the included columns.
There's no reason I shouldn't combine the included columns and just have one index, right?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
Yes, you should merge these indexes and only keep one, as long as you verify that:
Neither of them are marked as
UNIQUE (in which case, preserve that one)
Neither of them have a filter condition
Neither of them are expressly referenced in an index hint