I installed the mysql detection tool and found that there are many tables in metabase have redundant indexes.
I wanted to open an issue but didn't know which category to put it in, that's why I came to the here.
My current version is v0.46.2.
metabase.action DROP INDEX idx_action_public_uuid;
metabase.bookmark_ordering DROP INDEX idx_bookmark_ordering_user_id;
metabase.card_bookmark DROP INDEX idx_card_bookmark_user_id;
metabase.card_label DROP INDEX idx_card_label_card_id;
metabase.collection DROP INDEX idx_collection_personal_owner_id;
metabase.collection_bookmark DROP INDEX idx_collection_bookmark_user_id;
metabase.dashboard_bookmark DROP INDEX idx_dashboard_bookmark_user_id;
metabase.dashboard_favorite DROP INDEX idx_dashboard_favorite_user_id;
metabase.data_migrations DROP INDEX idx_data_migrations_id;
metabase.label DROP INDEX idx_label_slug;
metabase.login_history DROP INDEX idx_user_id;
metabase.login_history DROP INDEX idx_session_id;
metabase.metabase_field DROP INDEX idx_field_table_id;
metabase.metabase_table DROP INDEX idx_table_db_id;
metabase.metabase_table DROP INDEX idx_metabase_table_db_id_schema;
metabase.metric_important_field DROP INDEX idx_metric_important_field_metric_id;
metabase.native_query_snippet DROP INDEX idx_snippet_name;
metabase.parameter_card DROP INDEX idx_parameter_card_parameterized_object_id;
metabase.permissions DROP INDEX idx_permissions_group_id;
metabase.permissions DROP INDEX idx_permissions_group_id_object;
metabase.permissions_group DROP INDEX idx_permissions_group_name;
metabase.permissions_group_membership DROP INDEX idx_permissions_group_membership_user_id;
metabase.permissions_group_membership DROP INDEX idx_permissions_group_membership_group_id;
metabase.qrtz_fired_triggers DROP INDEX IDX_QRTZ_FT_TRIG_INST_NAME;
metabase.qrtz_triggers DROP INDEX IDX_QRTZ_T_STATE;
metabase.qrtz_triggers DROP INDEX IDX_QRTZ_T_G;
metabase.qrtz_triggers DROP INDEX IDX_QRTZ_T_NFT_MISFIRE;
metabase.query_execution DROP INDEX idx_query_execution_card_id;
metabase.report_card DROP INDEX idx_card_public_uuid;
metabase.report_cardfavorite DROP INDEX idx_cardfavorite_card_id;
metabase.report_dashboard DROP INDEX idx_dashboard_public_uuid;
metabase.sandboxes DROP INDEX idx_gtap_table_id_group_id;
metabase.timeline_event DROP INDEX idx_timeline_event_timeline_id;