No links seen from you, ever, on this thread. SQLite automatically chooses the best index from those available. The index it is choosing is probably better than the one you want it to use002E
> -----Original Message----- > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users- > bounces at mailinglists.sqlite.org] On Behalf Of Christoforus Surjoputro > Sent: Saturday, 27 February, 2016 09:47 > To: SQLite mailing list > Subject: Re: [sqlite] ASK SQLite algoritm to chose Index > > Hi Simon. > I've post it in stackoverflow link I gave before. About run ANALYZE, > SQLite still choose their own index instead Index that I've made. Thank > you. > > > On Saturday, February 27, 2016 12:49 AM, Simon Slavin > <slavins at bigfraud.org> wrote: > > > > On 26 Feb 2016, at 5:45pm, Christoforus Surjoputro <cs_sanmar at yahoo.com> > wrote: > > > I've problem with sqlite choosing index that I think I have better index > to use. I've ask here but still didn't get why this happen? Did sqlite > choose the best index to use or choose the last entered index? > > SQLite doesn't know which index was entered last.? It chose the best index > based on what it knows. > > Can you post your TABLE definition and the INDEXes you defined on the > table, and the result of EXPLAIN QUERY PLAN on your SELECT ? > > Please run ANALYZE, then do EXPLAIN QUERY PLAN on your SELECT again and > tell us if anything changed. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
