[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Cuirass] Missing database indexes?
From: |
Danny Milosavljevic |
Subject: |
Re: [Cuirass] Missing database indexes? |
Date: |
Tue, 13 Nov 2018 00:31:40 +0100 |
Hi Ludo,
On Sun, 11 Nov 2018 18:06:00 +0100
address@hidden (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.
pgpkyDTqhJv5t.pgp
Description: OpenPGP digital signature
- [Cuirass] Missing database indexes?, Ludovic Courtès, 2018/11/10
- Re: [Cuirass] Missing database indexes?, Björn Höfling, 2018/11/10
- Re: [Cuirass] Missing database indexes?, Ludovic Courtès, 2018/11/11
- Re: [Cuirass] Missing database indexes?, Björn Höfling, 2018/11/12
- Re: [Cuirass] Missing database indexes?, Amirouche Boubekki, 2018/11/12
- Re: [Cuirass] Missing database indexes?, Danny Milosavljevic, 2018/11/12
- Re: [Cuirass] Missing database indexes?, Ludovic Courtès, 2018/11/14
- Re: [Cuirass] Missing database indexes?, Björn Höfling, 2018/11/16
- Re: [Cuirass] Missing database indexes?, Clément Lassieur, 2018/11/13
- Re: [Cuirass] Missing database indexes?, Björn Höfling, 2018/11/16
- Re: [Cuirass] Missing database indexes?,
Danny Milosavljevic <=
- Re: [Cuirass] Missing database indexes?, Danny Milosavljevic, 2018/11/12
- Re: [Cuirass] Missing database indexes?, Ludovic Courtès, 2018/11/14
- Re: [Cuirass] Missing database indexes?, Danny Milosavljevic, 2018/11/19
Re: [Cuirass] Missing database indexes?, swedebugia, 2018/11/19