Summary

SHOW INDEXES will scan all tables and databases, so in the case of a large number of databases and tables, it will cause the query to be very slow, and sometimes I only care about the index of some tables

e.g.

SHOW INDEXES FROM your_table_name;