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.
