mysql_show_indexes
Display all indexes for a specified MySQL table to analyze database performance and optimize query execution.
Instructions
Show indexes for a specific table
Input Schema
Name | Required | Description | Default |
---|---|---|---|
database | No | Database name (uses current database if not specified) | |
table | Yes | Table name to show indexes for |