sql / beginner
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
1
DROP INDEX idx_employee_email;
Breakdown
1
DROP INDEX idx_employee_email;
Removes the index named 'idx_employee_email' from the database schema.