On Tue, 13 Nov 2018 00:31:40 +0100
Danny Milosavljevic <dannym@scratchpost.org> wrote:

> 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.

Also

https://www.sqlite.org/optoverview.html#autoindex