Database Indexing

Optimize query performance with indexes:

indexes: [
  // Single field index
  { fields: ['name'], unique: false },
  
  // Unique index
  { fields: ['email'], unique: true },
  
  // Compound index
  { fields: ['type', 'is_active'], unique: false },
  
  // Lookup field index
  { fields: ['owner'], unique: false },
]

When to Add Indexes

✅ Add indexes for:

• Lookup/reference fields
• Fields used in filters
• Fields used for sorting
• Fields in WHERE clauses
• High-cardinality fields

❌ Avoid indexes for:

• Low-cardinality fields (e.g., boolean)
• Fields rarely queried
• Frequently updated fields

See also

• Data Modeling overview
• Schema Design