Query B: MATCHCOLS=2 (ACCOUNT_ID equality, TRAN_DATE range). TRAN_TIME in key enables sort avoidance for ORDER BY. INCLUDE columns cover SELECT list except DESCRIPTION. Not fully index-only (DESCRIPTION not included) but eliminates most column fetches. - Query C: After partition pruning on TRAN_DATE