Переглянути всі індекси таблиці

SHOW INDEX FROM table_name;

+-------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
| Table | Non_unique | Key_name      | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | Ignored |
+-------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
| docid |          0 | PRIMARY       |            1 | doc_pref    | A         |        NULL |     NULL | NULL   |      | BTREE      |         |               | NO      |
| docid |          0 | PRIMARY       |            2 | doc_id      | A         |           6 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| docid |          0 | uni_typeserdt |            1 | doc_type    | A         |        NULL |     NULL | NULL   | YES  | BTREE      |         |               | NO      |
| docid |          0 | uni_typeserdt |            2 | doc_ser     | A         |        NULL |     NULL | NULL   | YES  | BTREE      |         |               | NO      |
| docid |          0 | uni_typeserdt |            3 | doc_dt      | A         |        NULL |     NULL | NULL   | YES  | BTREE      |         |               | NO      |
+-------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+