+-------+------------+---------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +-------+------------+---------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | aggr | 0 | PRIMARY | 1 | AGGR_ID | A | 36 | NULL | NULL | | BTREE | | | | aggr | 1 | AGGR_IDX_EDIT | 1 | AGGR_EDITINGADMINID | A | 4 | NULL | NULL | YES | BTREE | | | | aggr | 1 | AGGR_IDX_EDIT | 2 | AGGR_DELETEFLAG | A | 4 | NULL | NULL | YES | BTREE | | | | aggr | 1 | AGGR_IDX_EDIT | 3 | AGGR_ORGOBJID | A | 4 | NULL | NULL | YES | BTREE | | | +-------+------------+---------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ 4 rows in set (0.00 sec)