Snippet

Removing Unnecessary Indexes with DROP INDEX

The DROP INDEX statement removes an existing index from the database, helping reduce write overhead and free storage when an index is no longer beneficial.

snippet.sql

sql

DROP INDEX idx_employee_lastname;

Breakdown

DROP INDEX idx_employee_lastname;

Permanently deletes the specified index from the database to remove unused indexing overhead.

Previous snippet Next snippet

More Beginner SQL exercises →

Removing Unnecessary Indexes with DROP INDEX

Related