Hi
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.
Example :
table1 and table2 are linked by table3.
Table3 fields will look like this :
table1_id
table2_id
and indexes as follow :
PRIMARY(table1_id, table2_id)
FK_table1(table1_id)
FK_table2(table2_id)
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
performance ?
Of course, the storage engine used id InnoDB.
Thank you for your help and sorry for my english.
