How to Show Indexes in MySQL

Last updated July 25, 2026 · By the SaturnSQL team

SHOW INDEX FROM table lists every index with one row per column, including uniqueness and cardinality. Query information_schema.statistics for a compact one-row-per-index view or cross-database checks.

SHOW INDEX FROM orders;

SELECT index_name,
       GROUP_CONCAT(column_name ORDER BY seq_in_index) AS columns,
       MAX(non_unique) AS non_unique
FROM information_schema.statistics
WHERE table_schema = 'shop' AND table_name = 'orders'
GROUP BY index_name;