Comment by selcuka
3 years ago
Agreed. I once "optimised" an in-house software that took minutes to process a single report, down to seconds, just by adding an index to the database (Microsoft Access, mind you) table. Not all developers know what they are doing [1].
Had a coworker that just indexed everything, and it worked too.
To be fair knowing what to index is hard [1], but one would at least expect a developer to know that indexes are a thing.
[1] https://use-the-index-luke.com/3-minute-test