How did you optimize SQL queries, and how did the average report time decrease from 11-12 seconds to 9-10?

To optimize SQL queries that generate reports, I applied several approaches:

• Analyzing the execution plan of queries (EXPLAIN) to identify bottlenecks.
• Adding or adjusting indexes on columns involved in filtering and joins.
• Rewriting queries using more efficient JOINs or subqueries.
• Limiting the selection to only necessary fields and rows.
• Caching intermediate results if reports are built frequently with similar parameters.

As a result of these actions, the average report generation time decreased from 11-12 seconds to 9-10 seconds, which improved the overall system performance and user comfort.