If the predicate on TRANS_DATE were an equality instead of a range, MATCHCOLS could be 2. But the business requirement is a range, so MATCHCOLS = 1 is the best we can do with this index.