Snippet

Deleting Unused Database Indexes with DROP INDEX

Indexes speed up data retrieval but slow down write operations (INSERT, UPDATE, DELETE). Removing unneeded indexes with DROP INDEX frees storage space and improves write performance.

snippet.sql

sql

DROP INDEX idx_employee_email;

Breakdown

DROP INDEX idx_employee_email;

Removes the index named 'idx_employee_email' from the database schema.

Previous snippet Next snippet

More Beginner SQL exercises →

Deleting Unused Database Indexes with DROP INDEX

Related