Drop Index and it runs faster

Russell 2017-08-31 19:12:24

If I drop index node 13 the query will pick a better index and run faster with few records. Why doesn't it pick the better index instead. the better index is IX_A01C_Accountnumber_CodeType_Codevalue instead of IX_A01c_CodeType_Active_CodeValue_Include_KCM