indexes_sample.py

# create indexes using Field.db_index value
class Product(models.Model):
    name = models.CharField(max_length=128, db_index=True)
    upc = models.CharField(max_length=32, unique=True)
    category = models.ForeignKey(
        Category, on_delete=models.PROTECT, related_name='categories', null=True)
    created_by = models.ForeignKey(
        User, on_delete=models.PROTECT, related_name='product_created_by', null=True)
    
    
# create indexes using Meta.indexes option
class Product(models.Model):
    name = models.CharField(max_length=128)
    upc = models.CharField(max_length=32, unique=True)
    category = models.ForeignKey(
        Category, on_delete=models.PROTECT, related_name='categories', null=True)
    created_by = models.ForeignKey(
        User, on_delete=models.PROTECT, related_name='product_created_by', null=True)
    
    class Meta:
        indexes = [
            models.Index(fields=['name'], name='product_name_idx'),
        ]