I do not see a link ... do you see a link?
> -----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 21:12
> To: SQLite mailing list
> Subject: Re: [sqlite] ASK SQLite algoritm to chose Index
>
> This i the link: SQLite use autoindex instead my own index
> | ? |
> | ? | | ? | ? | ? | ? | ? |
> | SQLite use autoindex instead my own indexI've problem with SQLite
> autoindex in UNIQUE table. I've create table like below.
> c.execute('''CREATE TABLE user( id INTEGER PRIMARY KEY, email TEXT NOT...
> |
> | |
> | View on stackoverflow.com | Preview by Yahoo |
> | |
> | ? |
>
>
>
>
>
> On Sunday, February 28, 2016 12:44 AM, Keith Medcalf
> <kmedcalf at dessus.com> wrote:
>
>
>
> 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
>
>
>
> _______________________________________________
> 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
