Check secondary index (2i) existence
Check if an index exists and view its definition using the DESCRIBE TABLE
command.
Prerequisites
-
-
Verify that an index exists:
DESCRIBE INDEX cycling.blist_keys_idx;
-
View the index definition:
CREATE INDEX blist_keys_idx ON cycling.birthday_list (keys(blist));
-