http://hi.baidu.com/wylinux/item/cbc458c2984381300831c651 View Index Commands
Mysql> Show index from Tblname;
Mysql> show keys from Tblname;
· Table
The name of the table.
· Non_unique
0 if the index cannot include a repeating word. 1 if it is possible.
· Key_name
The name of the index.
· Seq_in_index
The column sequence number in the index, starting at 1.
· column_name
The column name.
· Collation
The column is stored in the index in what way. In MySQL, there is a value of ' A ' (ascending) or null (no classification).
· Cardinality
An estimate of the number of unique values in the index. You can update by running analyze table or myisamchk-a. The cardinality is counted according to the statistics stored as integers, so even for small tables, this value is not necessarily accurate. The larger the cardinality, the greater the chance that MySQL will use the index when it is federated.
· Sub_part
The number of characters that are indexed if the column is only partially indexed. Null if the entire column is indexed.
· Packed
Indicates how the keyword is compressed. Null if it is not compressed.
· Null
If the column contains null, it contains Yes. If not, the column contains No.
· Index_type
Used indexed methods (BTREE, Fulltext, HASH, RTREE).
· Comment
More commentary.
MySQL Query table index command in detail
