How would you optimize a query that is running slowly on a massive dataset of historical payment transactions at PRA Group?
