database indexes are so weird and magical. like i have no idea how they work or what they do, i just know when stuff is slow, throw a database index at it and everything gets fast. i wonder if it would be possible to design database software that can automatically identify and apply missing indexes.