From sqlite-users  Tue Jul 26 09:17:00 2016
From: Luca Ferrari <fluca1978 () infinito ! it>
Date: Tue, 26 Jul 2016 09:17:00 +0000
To: sqlite-users
Subject: Re: [sqlite] sqlite 3.13.0 does not use indexes as 3.8.11.1 does
Message-Id: <CAKoxK+4373ODEt4QNMsC3VHUH7fWH2fMoL=f72e1_TzX+0sY1A () mail ! gmail ! com>
X-MARC-Message: https://marc.info/?l=sqlite-users&m=146952463313005

On Tue, Jul 26, 2016 at 10:37 AM, Alessandro Fardin
<Alessandro.Fardin@gavazziacbu.it> wrote:
> As temporary  work around we have have added to the query the INDEXED BY
> energy_d_dateTimeIdx statement.
>
> In sqlite 3.8.11.1 the select was issued by using the
> energy_d_dateTimeIdx index

Any chance the optimizer thinks the table is too small to use the index?
Is the data in the table the same before and after the update (meaning
as tuple count size)?
Could you provide the explain?

Luca
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users