[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] sqlite 3.13.0 does not use indexes as 3.8.11.1 does
From:       Luca Ferrari <fluca1978 () infinito ! it>
Date:       2016-07-26 9:17:00
Message-ID: CAKoxK+4373ODEt4QNMsC3VHUH7fWH2fMoL=f72e1_TzX+0sY1A () mail ! gmail ! com
[Download RAW message or body]

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
[prev in list] [next in list] [prev in thread] [next in thread]