Hi Ludo,

On Sun, 11 Nov 2018 18:06:00 +0100
ludo@gnu.org (Ludovic Courtès) wrote:

> I don’t really know what additional index to create (and I’d rather let
> SQLite do it for me, if it were possible).

Not exactly what you mean but there's this:

https://www.sqlite.org/lang_analyze.html

It does statistical analysis of queries that ran and will optimize for
that case on subsequent connections.

Other than that, I always create indices by hand since it's a one-time
effort anyway - so just searching for a solution to automate it takes
longer than just adding an index for a column I match on.