On Tue, 13 Nov 2018 00:31:40 +0100 Danny Milosavljevic <dan...@scratchpost.org> wrote:
> Hi Ludo, > > On Sun, 11 Nov 2018 18:06:00 +0100 > l...@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
pgpdwwSGCEYSy.pgp
Description: OpenPGP digital signature
