Re: [sqlite] Plan not optimized ?

. 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 returns: SCAN TABLE c (~74 rows) EXECUTE

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, total+2 FROM v_c returns

[sqlite] Plan not optimized ?

+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 MANKOWSKI ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo

[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