Database Indexing Example
A snippet showing how to add database indexes in Django models.
# models.py
from django.db import models
class Customer(models.Model):
email = models.EmailField(unique=True, db_index=True)
created_at = models.DateTimeField(auto_now_add=True,)
class Meta:
indexes = [
models.Index(fields=["created_at"]),
]
Explanation:
- email index speeds up queries filtering by email.
- created_at index speeds up queries filtering by creation date.
- Greatly improves performance for frequently queried fields.
- Category Performance & Optimization
- Total Views 556
- Last Modified 01 May, 2026
- Tags #performance #indexing #database #models
Previous snippet
Use prefetch_related for Many-to-Many
Next snippet