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]