>I want to store a conditional sum of either one or two columns. Do you still think the view is a way to go ?
>
>Thank you,
>daniel
In my opinion ANY computed columns, Columns results of Aggregate functions MUST be ONLY in queries or views. No need to store them in actual tables, this is just waste of space and performance. How do you plan to maintain that column? If you change the value of A you must also change the value of that column. If you put it in View and base your queries on that view instead of actual table you always will have computed column with valid data in it. Also if you didn't want to have view you always can add that column in your queries.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.