Re: Composite Indexing

On Mon, 2009-01-19 at 16:55 -0800, Andrew Fong wrote: > I'm using contrib.contenttypes and have added the following to my > model: > > content_type = models.ForeignKey(ContentType) > object_id = models.PositiveIntegerField() > content_object = generic.GenericForeignKey() > > When examining the D

Composite Indexing

I'm using contrib.contenttypes and have added the following to my model: content_type = models.ForeignKey(ContentType) object_id = models.PositiveIntegerField() content_object = generic.GenericForeignKey() When examining the DB (I'm using MySQL), I find that content_type is indexed but object_id