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