3 ms·
Related: https://sqlite.org/cli.html#index_recommendations_sqlite_expert_ https://sqlite.org/cli.html#index_recommendations_sqlite_exp... There's an experimen
by banana_giraffe 4y ago
Related: https://sqlite.org/cli.html#index_recommendations_sqlite_expert_ 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.
- parentheses 4y agoI'd like to see this in Postgres and the like.
- masklinn 4y agoDefinitely 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.