How would you optimize a slow-running SQL query that is joining multiple billion-row tables at BHG Financial?