SHOW INDEX

description

1. This statement is used to show all index(only bitmap index in current version) of a table
2. Grammar:
3. SHOW INDEX[ES] FROM [db_name.]table_name [FROM database];

5. OR

7. SHOW KEY[S] FROM [db_name.]table_name [FROM database];

example

1. 1.  dispaly all indexes in table table_name
2. SHOW INDEX FROM example_db.table_name;

keyword

1. SHOW,INDEX