News for hackers. Stuff that matters.
Re:SQLite's Automatic Indexes by banana_giraffe on Wednesday December 28, 2022 @12:20PM (#34163257)
Related: https://sqlite.org/cli.html#index_recommendations_sqlite_exp...

There's an experimental module and CLI command in the normal shell to use this logic to dump out a suggested list of indexes to create for a given SQL command to speed it up.

Re:SQLite's Automatic Indexes by parentheses on Wednesday December 28, 2022 @03:41PM (#34165671)
I'd like to see this in Postgres and the like.
Re:SQLite's Automatic Indexes by masklinn on Wednesday December 28, 2022 @03:45PM (#34165732)
Definitely would be nice in pg. I think it exists for sql server (likely also oracle), iirc the db can even be configured to optimistically create the index to try it out, and revert it if it’s bad.

One of the difficulties is indexes have a write cost so heuristically deciding on the trade off can be complicated.