Sample Header Ad - 728x90

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