create_index
Create an index on specified columns in an MSSQL database table to improve query performance and enforce uniqueness or clustering as needed.
Instructions
Creates an index on a specified column or columns in an MSSQL Database table
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| columns | Yes | Array of column names to include in the index | |
| indexName | Yes | Name for the new index | |
| isClustered | No | Whether the index should be clustered (default: false) | |
| isUnique | No | Whether the index should enforce uniqueness (default: false) | |
| schemaName | No | Name of the schema containing the table | |
| tableName | Yes | Name of the table to create index on |