Drop an index

sql

DROP INDEX idx_orders_created_at ON orders;

Explanation

Dropping unused indexes can reduce write amplification and storage cost.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing indexes

Add an index for a frequently filtered column.

Open In sheetsqlsame section

Index multiple columns in left-to-right order.

Open In sheetsqlsame section

Display index metadata for a table.

Open In sheetsqlsame section

View the optimizer's execution plan.

Execute the query and include actual timing information.

Update optimizer statistics for a table.