Query to Optimized Query

Workflow · 2 phases

1. 1

   Phase 1: Phase 1 — Working query

   CodeRecommended: Tabnine

   Copy phase 1

   Generate a [DATABASE] query that [BASIC NEED]. Just get the correct results first — clarity over speed. Query: describe what you need in plain words.

2. 2

   Phase 2: Phase 2 — Optimize it

   CodeRecommended: Tabnine

   Copy phase 2

   Now optimize that query for a table with 10M+ rows: rewrite with proper indexes in mind, eliminate N+1 patterns, and explain which index you would add and why. Show EXPLAIN-style reasoning.