create_index
Create database indexes on SQL Server tables to improve query performance by organizing data for faster retrieval and enforcing unique constraints when 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 |
Input Schema (JSON Schema)
{
"properties": {
"columns": {
"description": "Array of column names to include in the index",
"items": {
"type": "string"
},
"type": "array"
},
"indexName": {
"description": "Name for the new index",
"type": "string"
},
"isClustered": {
"default": false,
"description": "Whether the index should be clustered (default: false)",
"type": "boolean"
},
"isUnique": {
"default": false,
"description": "Whether the index should enforce uniqueness (default: false)",
"type": "boolean"
},
"schemaName": {
"description": "Name of the schema containing the table",
"type": "string"
},
"tableName": {
"description": "Name of the table to create index on",
"type": "string"
}
},
"required": [
"tableName",
"indexName",
"columns"
],
"type": "object"
}