View Index mysql> Show index from tblname;mysql> show keys from tblname; The name of the table sheet. Non_unique 0 If the index cannot include a repeating word. 1 if it is possible. · The name of the Key_name index. Seq_in_index the column sequence number in the index, starting at 1. COLUMN_NAME column name. How the collation column is stored in the index. In MySQL, there is a value of ' a ' (ascending) or null (no classification). An estimate of the number of unique values in the cardinality 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 If the column is only partially indexed, the number of characters that are 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 index Method (BTREE, Fulltext, HASH, RTREE). Comment
MySQL View data table index Information
