Do you know how to view indexes of a table in MySQL?
I found a solution to the problem.
SHOW INDEX FROM `table_name` FROM `database_name`;
SHOW INDEX FROM `database_name`.`table_name`;
Another solution when already using database is the following query:
SHOW INDEXES FROM `table_name`;