Can you describe a specific instance where you optimized a SQL query, and what was the impact on performance?

Technical