create_index
Create database indexes on MSSQL table columns to improve query performance and enforce data uniqueness.
Instructions
Creates an index on a specified column or columns in an MSSQL Database table
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schemaName | No | Name of the schema containing the table | |
| tableName | Yes | Name of the table to create index on | |
| 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) |