How would you optimize a slow-running query that joins a high-volume user activity log table with a static user profile table at Truebill?