If we could arrange for TRANSACTIONS to be accessed in TRANS_DATE DESC order, we could eliminate the sort. But that would conflict with the ACCT_ID-first access through the nested loop. There may be no way to avoid this sort.