Use the "show create table" command to see the index.
# Check index show create table book;
You can see the index definition in the row named "KEY".
KEY `book_author_id` (`author_id`)
If you want to create an index, please refer to the following articles.
If you want to delete the index, please refer to the following article.