I want to optimize my MySQL schema in order to increase performance of my
application. And I see several points that could be corrected but I am not
sure what would be the impacts and benefits.
One example, MySQL Workbench create indexes for all foreign keys even on
many-to-many relationship table causing index duplication.
table1 and table2 are linked by table3.
Table3 fields will look like this :
and indexes as follow :
FK_table1 is not necessary.
If I drop this index, when will I see benefits ? Only on inserts ?
I will certainly win few disk space too, but will it increase select
Of course, the storage engine used id InnoDB.
Thank you for your help and sorry for my english.