• I understand what's been said.

    But I still don't see why the first index is more "correct" when it requires trolling through thousands of records to find just the few for an account when the second index goes directly to the few records for the account.

    Doesn't the equality comparison on the AccountNumber column make the second index a better choice than the first index?