InnoDB foreign key constraint columns are automatically indexed Leave a Comment / Database / March 13, 2016 March 13, 2016 So you don’t have to create an index manually on the foreign key columns.