create_index
Improve database query performance by creating indexes on specified columns in MSSQL tables to optimize data retrieval and enforce uniqueness constraints.
Instructions
Creates an index on a specified column or columns in an MSSQL Database table
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| tableName | Yes | Name of the table to create index on (can include schema: schema.table) | |
| indexName | Yes | Name for the new index | |
| columns | Yes | Array of column names to include in the index | |
| isUnique | No | Whether the index should enforce uniqueness (default: false) | |
| isClustered | No | Whether the index should be clustered (default: false) |