mysql> SHOW INDEXES FROM zeroseventwo_forummessages; +----------------------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | +----------------------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+ | zeroseventwo_forummessages | 0 | PRIMARY | 1 | messageid | A | 318 | NULL | NULL | | BTREE | | | zeroseventwo_forummessages | 1 | fromuid | 1 | fromuid | A | 39 | NULL | NULL | YES | BTREE | | | zeroseventwo_forummessages | 1 | thread | 1 | thread | A | 2 | NULL | NULL | YES | BTREE | | | zeroseventwo_forummessages | 1 | touid | 1 | touid | A | 79 | NULL | NULL | YES | BTREE | | | zeroseventwo_forummessages | 1 | senttime | 1 | senttime | A | 318 | NULL | NULL | YES | BTREE | | | zeroseventwo_forummessages | 1 | messageid | 1 | messageid | A | 318 | NULL | NULL | | BTREE | | | zeroseventwo_forummessages | 1 | messageid | 2 | touid | A | 318 | NULL | NULL | YES | BTREE | | +----------------------------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+ 7 rows in set (0.00 sec)