Unused indexes still hurt writes and consume disk.
Section: Anti-patterns
Remember unused index cost
text
text
Every INSERT, UPDATE, and DELETE may need to update every relevant index.Explanation
Unused indexes are not free and should be reviewed periodically.
Learn the surrounding workflow
Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.
Related commands
Same sheet · prioritizing Anti-patterns
Avoid duplicate or overlapping indexes
Do not keep several indexes that serve the same leading prefix needlessly.
Be careful with low-cardinality flags
A boolean by itself is often weak unless paired with something else or made partial.
SQLite VACUUM after major churn
Compact the file after heavy changes when appropriate.