I'm a bit confused by the different approaches here. I'll need to review the details of each solution to understand the implications and decide which one would work best for this scenario.
I'm feeling pretty confident about this one. The query is filtering on the city name, so adding a regular index on that column (option D) should improve the performance by allowing the database to quickly locate the relevant rows.
Lavelle
4 months agoHaydee
4 months agoAlton
4 months agoRene
4 months agoJohna
5 months agoMireya
5 months agoAshley
5 months agoEarleen
5 months agoKatie
5 months agoMica
5 months agoDierdre
5 months agoLigia
5 months ago