On Sat, 2009-04-18 at 21:22 -0700, meppum wrote: > I noticed that there is a unique constraint and maybe that infers an > index, but if it doesn't, why isn't an index on this column needed?
The unique constraint does provide an index. Otherwise inserts would be very inefficient for the database, because it would have to sequential scan the entire table before inserting a row. Regards, Malcolm --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---