Index consolidation of two similar indexes
0
votes
1
answer
61
views
We have a primary table that drives most of the work within our product with many columns.
Index 1 has a key consisting of: Column A, Column B, Column C, Column D
Index 2 has a key consisting of: Column D, Column A, Column B
The Includes are nearly identical, except Index 2 has Column C as an include when Index 1 has it in the key.
Would Index 2 be a candidate to drop in favor of Index 1?
Asked by Brian
(3 rep)
Apr 27, 2023, 02:43 PM
Last activity: Apr 27, 2023, 03:09 PM
Last activity: Apr 27, 2023, 03:09 PM