How would you optimize a query that joins multiple high-volume transactional tables, such as shift bookings and user activity logs, at Clipboard?
