2 ms·
Indexes are useful for speeding up select statements but they run a significant cost on insert and update. Sometimes it's better not to index, if you have a ta
by jaggederest 9y ago
Indexes are useful for speeding up select statements but they run a significant cost on insert and update.
Sometimes it's better not to index, if you have a table that is updated often and queried in varying, complex, rarely repeated ways.
- BurningFrog 9y agoYeah, I'm aware of that, and I'm sure these cases exist, but after 20 years around these things I have yet to see one in real life.
- jaggederest 9y agoFWIW I've worked for multiple companies where tables couldn't reasonably be indexed. Special cases though, usually write-only analytic tables that are queried once in a blue moon and have incredibly high traffic (~millions of rows per hour).