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
10 months agoHaydee
10 months agoAlton
10 months agoRene
10 months agoJohna
10 months agoMireya
11 months agoAshley
11 months agoEarleen
11 months agoKatie
11 months agoMica
11 months agoDierdre
11 months agoLigia
11 months ago