Do I need to add a db_index to this Django model?

Question

class Comments(models.Model):
    content = models.ForeignKey(Content)

Do I need to add a db_index to "content"? Or would that automatically be indexed because it's a foreign key?

Sam Dolan · Accepted Answer · 2011-01-29 10:32:14Z

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

answered Jan 29, 2011 at 10:32

Sam Dolan

32.6k10 gold badges93 silver badges84 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jeffrey Bauer Over a year ago

To disable creation of an index on a ForeignKey, set db_index=False: code.djangoproject.com/ticket/13730

Collectives™ on Stack Overflow

Do I need to add a db_index to this Django model?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related