| Subject | firebird computed field | 
|---|---|
| Author | Wewe | 
| Post date | 2013-08-02T08:54:03Z | 
whether the computed field affect the performance and  speed of the table?
simple example :
table x
value1 integer
value2 integer
total computed(value1+value2)
table y
value1 integer
value2 integer
query1
[Non-text portions of this message have been removed]
            simple example :
table x
value1 integer
value2 integer
total computed(value1+value2)
table y
value1 integer
value2 integer
query1
> select * from xquery2
> select total from x
> select * from yWhich is better performance and speed? table x or table y ?
> select value1+value2 as total from y
[Non-text portions of this message have been removed]