While you're waiting, you might think about recasting the query to
avoid the OR. Perhaps you could do a UNION of two scans of the
transactions table?
Minor note- use UNION ALL to avoid the dedupe work if you already know those will be distinct sets, or having duplicates is fine.
