create_index
Define and create new indexes on specified table columns to optimize query performance and enhance data retrieval efficiency for read-heavy workloads.
Instructions
Create a new index on a specified table to improve query performance. This tool allows users to define indexes on one or more columns, enabling faster data retrieval and optimized execution plans for read-heavy workloads.
Args: table_name (str): Name of the table. index_name (str): Name of the index. columns (List[str]): List of column names to include in the index.
Returns: A success message or an error message.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| columns | Yes | ||
| index_name | Yes | ||
| table_name | Yes |