Re: [sqlite] Plan not optimized ?

ion" is the best solution for me. Thank you in advance for your help. Regards, Stephane Le samedi 4 juin 2011 12:36:47, Richard Hipp a écrit : > 2011/6/3 Stéphane MANKOWSKI <steph...@mankowski.fr> > > > 4-EXPLAIN QUERY PLAN SELECT total, total+1, total+2 FROM v_c >

Re: [sqlite] Plan not optimized ?

Hi, Thank you for the answer. Do you know if it's planned ? Do you know a workaround? Regards, Stephane Le samedi 4 juin 2011 12:36:47, Richard Hipp a écrit : > 2011/6/3 Stéphane MANKOWSKI <steph...@mankowski.fr> > > > 4-EXPLAIN QUERY PLAN SELECT total, total+1

[sqlite] Plan not optimized ?

ormal ? Do you know I can optimize my view to have only one "CORRELATED SCALAR" ? I tried "EXPLAIN QUERY PLAN SELECT total, total+1, total+2 FROM (select total from v_c)" but I have the same result. In advance, thank you for your help and your very good tool ! Regards, Stéphane

[sqlite] Performance issue on view

Hi, In the this database file (http://skrooge.org/files/test.wrk), I created a table named "op" containing banking transactions. A transaction has: An unique id An account A date An amount I created a view named "v_op" with one more computed attribute named