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
