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.
pgputRYYNc5Vb.pgp
Description: OpenPGP digital signature
