drop_index

Use the drop index operation to drop vector or metadata indexes from a vector table.

Removes the index while preserving the table and its data. Queries will fall back to exact search until a new index is created. ORDS 26.2 requires a request body for this operation.

Parameters

Parameter	Type	Value Range	Required	Default	Description	Notes
table_name	str	Valid vector table identifier	Yes	No default	Name of the vector table whose index to drop.	Table must exist in the database schema.
index_params	dict	Object or NULL	No	None	Specifies whether to drop the vector index, metadata index, or both (all) for the vector table using index_type.
debug_flags	dict	Object or NULL	No	None	Debug or tracing flags for detailed logging.	Optional; omit unless diagnostics are needed.

Raises Exception – InvalidTableNameFormatError may be raised when the table name is invalid. The operation also fails if the table or index does not exist.

Drop an index and inspect the response

result = client.drop_index(
    table_name="products",
    index_params={"index_type": "all"},
)
print(result)

Return type DropIndexResponse

Returns JSON response confirming index deletion. Example response:

{
    "message": "Index drop request submitted."
}