Loading…
A short voice session: one question, one follow-up, then instant feedback — up to 5 minutes.
Measure the real query and inspect its plan using representative data. Align indexes and result limits with filtering, ordering, and pagination needs.
Look for full scans, unnecessary sorting, repeated per-row queries, and loading columns the screen does not need. A compound index can support a particular filter and order combination, but column order and selectivity matter. Indexes also consume storage and slow writes, so do not add one blindly for every field. Re-measure latency and write cost, and verify results and migration behavior.