How would you optimize a slow-running SQL join between a massive claims history table and a smaller, frequently updated policy table?