In one of my projects, I needed to retrieve data from multiple tables with complex joins and filtering conditions. Initially, the query was slow due to unindexed columns. After analyzing the execution plan, I added proper indexes and optimized the JOIN order, which significantly improved performance. I also used EXPLAIN to verify the changes.