get_table_indexes
Retrieve indexes for a specified table in Oracle databases. Input the table name and optional schema to identify and analyze relevant indexes for database optimization and query performance.
Instructions
Get indexes for a specific table
Input Schema
Name | Required | Description | Default |
---|---|---|---|
schema | No | Schema name (optional, searches all accessible schemas if not specified) | |
table_name | Yes | Table name |
Input Schema (JSON Schema)
{
"properties": {
"schema": {
"description": "Schema name (optional, searches all accessible schemas if not specified)",
"type": "string"
},
"table_name": {
"description": "Table name",
"type": "string"
}
},
"required": [
"table_name"
],
"type": "object"
}