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
select * from x
select total from x
query2
select * from y
select value1+value2 as
-- Original Message ---
From: Wewe sullen...@yahoo.com
select * from y
select value1+value2 as total from y
Which is better performance and speed? table x or table y ?
--- End of Original Message ---
I've never noticed a difference in performance at select time. I