To view the status of indexes in a table use the following statement; SHOW INDEX FROM <table>; Example: mysql> SHOW INDEX FROM countrylanguage\G *************************** 1. row *************************** Table: countrylanguage Non_unique: 0 Key_name: PRIMARY Seq_in_index: 1 Column_name: CountryCode Collation: A Cardinality: NULL Sub_part: NULL Packed: NULL Null: Index_type: BTREE Comment: *************************** 2. row *************************** Table: countrylanguage Non_unique: 0 Key_name: PRIMARY Seq_in_index: 2 Column_name: Language Collation: A Cardinality: 984 Sub_part: NULL ...
“The best way to be ready for the future is to invent it.”— John Sculley