I need to maintain 1 million rows that contain calculations (Data in TableA x Data in TableB) . If it was a smaller amount of rows I would most probably just use a view so if the data in TableA changed the view would automatically be maintained.
As the amount of rows in the view would be around a million I would guess this is not the most efficient way of doing things?
Question is what is the best way to maintain this amount of calculations. The data in TableA and/or TableB will change frequently and the view (or what ever someone proposes??) will need to be updated to reflect the changes to TableA & B.