SQL DROP INDEX

query.sql

…

Expected output

Lesson notes

DROP INDEX

Remove an index.

DROP INDEX

DROP INDEX removes an index. Unused indexes are cleaned up.

DROP INDEX idx_name;

This query removes the index.

DROP INDEX — details

Some databases use DROP INDEX idx_name ON customers. Syntax may vary.

Dropping unused indexes speeds up writes and saves disk space.

Exercise DROP INDEX

Remove the idx_name index with DROP INDEX.

Show example solution

DROP INDEX idx_name;

Test yourself

What does DROP INDEX do?
- Drops the table
- Deletes the data
- Removes the index
- Stops the query
Show answer

Removes the index — DROP INDEX removes the index.
Add DROP INDEX
```
DROP ____ idx_name;
```
Show answer
```
DROP INDEX idx_name;
```
DROP INDEX: match the terms

DROP INDEX

remove
CREATE INDEX

create
unused

clean
data

unaffected

Next lesson: When to index