Database software often will create automatic indexes based on the queries it gets. Even SQLite has this: https://www.sqlite.org/optoverview.html#autoindex ht

Database software often will create automatic indexes based on the queries it gets. Even SQLite has this: https://www.sqlite.org/optoverview.html#autoindex https://www.sqlite.org/optoverview.html#autoindex If your db is read-mostly, manually adding a bunch of indexes based on a statistical analysis of actual queries might be useful. If you have a lot of writes it becomes a tricky balancing act because every index has the potential to slow down writes while speeding up reads.