create_index
Add an index to a MySQL table to improve query performance by specifying columns, index name, and optional uniqueness constraints.
Instructions
Create an index on a table
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | Table name | |
| indexName | Yes | Index name | |
| columns | Yes | Column names to index | |
| unique | No | Whether this is a unique index | |
| database | No | Database name (optional) |