On 4/14/16, John Found <johnfound at asm32.info> wrote: > > But after some time working in wild (executing the more complex original > query), the performance decreased again and despite of existing the index, > the result of the "explain query plan" is again: > > SCAN TABLE T > USE TEMP B-TREE FOR ORDER BY
Can you make a copy of the database when it gets into this state, and send it to us for analysis? -- D. Richard Hipp drh at sqlite.org
