[Django]-Do I need to add a db_index to this Django model?

44👍

Unless specified otherwise, an index will be created for a ForeignKey. Relevant source code:

class ForeignKey(RelatedField, Field):
    # snip
    def __init__(self, to, to_field=None, rel_class=ManyToOneRel, **kwargs):
        # snip
        if 'db_index' not in kwargs:
            kwargs['db_index'] = True

Leave a comment