Re:The SQLite Index Suggester
by abraae on Tuesday July 05, 2022 @04:28PM
(#31993286)
Oracle (and likely others) have had this since well into the last century. As you might expect since it can save a huge amount of money on a large database, it's part of an (expensive) add on.
[ Parent
| on HN ]
Oracle can also do it autonomously if you have the super duper expensive package. It finds useful indexes based on what's queried regularly, tries them out behind the scenes to see if it'd improve things, and then creates them if they'd be useful.