Provide exact CREATE INDEX statements (with CONCURRENTLY) and predict the

plan changes. Note write-amplification trade-offs. 5. Suggest denormalization or caching only if indexes/rewrites are insufficient. Here is the context: QUERY: {{SQL}} SCHEMA: {{DDL}} EXPLAIN ANALYZE: {{PLAN}} TARGET: p95 under {{X}} ms at {{N}} rows. ================================================================================