How would you optimize a SQL query that involves joining a high-volume telemetry fact table with a slow-moving dimension table?
