Re: storing averages in a separate data
I'm no expert, but I imagine it violates normalization as your average is computable from other data... It does make sense if you only look into performance.
INSERT: One problem would be that if the first insert is completed, but the average computation has problem, what do you do?
UPDATE: The other problem would arise if you modify any information. Let's say you made a typo and added 1000 shares at 4$ instead of 100. You would then have to correct two places, etc...
DELETE: Same as update.. you would have to recompute the average...
Hope this helps,
H.
Subject
Written By
Posted
Re: storing averages in a separate data
May 23, 2008 12:47PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.