id,summary,reporter,owner,description,type,status,component,version,severity,resolution,keywords,cc,stage,has_patch,needs_docs,needs_tests,needs_better_patch,easy,ui_ux
18046,document index created for a ForeignKey,jbauer@…,Raúl Cumplido,"It would be helpful if the Model field docs mentioned that Django automatically creates an index for ForeignKey columns.
https://docs.djangoproject.com/en/dev/ref/models/fields/#foreignkey
The docs could also mention how to disable this behavior (db_index=False) and why the user may want to do this:
* FK created for consistency, not joins
* alternative special indexes (partial, multiple column, etc) will be created instead
Relevant links:
* https://code.djangoproject.com/ticket/13730
* http://stackoverflow.com/questions/4836327/do-i-need-to-add-a-db-index-to-this-django-model
* http://stackoverflow.com/questions/5984842/django-does-it-automatically-generate-indexes-for-foreign-keys-columns
",Cleanup/optimization,closed,Documentation,1.4,Normal,fixed,ForeignKey db_index,raulcumplido@… timograham@…,Accepted,1,0,0,0,1,0