How do you optimize a SQL query when joining multiple large datasets to ensure performance efficiency?
