I am pretty sure that you should add some index on the new DamageState table you have created (lsi ?). Which kind of query do you expect to occur on the new (and modified) output tables?