Skip to main content
Missing indexes usually reveal themselves through slow filters, slow sorts, or heavy document scans.

​
Process

  1. identify the real query
  2. run explain
  3. inspect current indexes
  4. propose the smallest index that fits the workload

​
Avoid

  • adding duplicate indexes
  • indexing every field by instinct
  • ignoring compound key order