Same index name for two tables

Question

I am working on creating a small Mysql database for our team. For two tables in my db, I used the same index name.

Will there be any performance hit?

I have made some test queries (800,000 + rows) and so far, so good.

Answer 1

Index names refer to each table. You cannot have two indexes with the same name in the same table, but you can have many indexes with the same name, one for each table. Index names do not matter for everyday work. They are just there to provide a convenient and convenient way to reference an index without having to list all the fields in the index. For example, it’s easier to say alter table XXX drop key friendlynamethanalter table XXX drop key (field1, field2, field3, field4, field5, etc...)

Answer 2

Index names for each table should not be any problem.

Answer 3

. .