I am looking forward suggestions and solutions. I have a table and
would like to add a "computed column" for reporting performance
reason. The value of the column is calculated based on the columns on
other tables. For example:
I have tables A, B, C.
A inclues columns a_id, b_id, a_name
B inclues columns b_id, b_name, b_insert_timestamp
C inclues columns a_id, computed column c_computed.
The c_computed is defined as something like:
if (b_name is presented in B and b_insert_timestamp < "Dec. 31, 2002"
and C.a_id = A.a_id and A.b_id = B.b_id)
Or is ...