Description

List all indexes of the specified table

Syntax

SHOW INDEX FROM [schema].table_name;

Usage Example

1. Query the Bloom filter index of the table named users in the default database:

SHOW INDEX FROM users;

2. Query the Bloom filter index of the table named `orders` in the database named `my_schema`:

SHOW INDEX FROM my_schema.orders;