Performance of a query having multiple equality type predicates improves as it switches from using the index on an unselective column to a selective one.
This is a companion discussion topic for the original entry at https://blog.toadworld.com/index-selectivity-queries-with-multiple-equality-conditions