An application database has grown, and an unindexed filter now scans most rows for each request. Which improvement should precede an expensive instance upgrade?

1. Increase instance size repeatedly without inspecting queries.
2. Disable all slow-query evidence collection.
3. Analyze database load and query plans, then test a suitable index or query rewrite.
4. Change the database DNS name as the sole optimization.