mination" 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
>
> > 4-EXPLAIN QUERY PLAN SELECT total, total+1, total+2 FROM v_c
> >
> > ret
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
>
> > 4-EXPLAIN QUERY PLAN SELECT total, total+1, total+2 FROM v_c
> >
>
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
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
"ba
4 matches
Mail list logo