[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 01:04:58 +0100 |
On Tue, 13 Nov 2018 00:31:40 +0100
Danny Milosavljevic <address@hidden> wrote:
> 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.
Also
https://www.sqlite.org/optoverview.html#autoindex
pgpiJgOR8XeUp.pgp
Description: OpenPGP digital signature
- Re: [Cuirass] Missing database indexes?, (continued)
- 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, 2018/11/12
- Re: [Cuirass] Missing database indexes?,
Danny Milosavljevic <=
- 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