Hi,
Would it be possible to show a message when someone creates a useless index
such as index 'x' below?
(at least if you have a logger defined via SQLITE_CONFIG_LOG)
sqlite create table foo(a int, b int);
sqlite create index x on foo(a,b) where a=0 and b=0;
sqlite explain query plan select *
On 23 May 2014, at 1:26pm, Török Edwin edwin+sqli...@etorok.net wrote:
Also it might be nice to show a message (or a warning via SQLITE_CONFIG_LOG)
when you run 'explain query plan'
and there are indexes (either manual or implicit), but they were rejected for
some reason.
The index that
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 23/05/14 05:26, Török Edwin wrote:
Would it be possible to show a message when someone creates a useless
index
There was a ticket from two years requesting a lint mode to catch
various issues that keep cropping up over the years: