I have a Product table that includes Price1, Price2, and Price3 fields.
Some products can have 1 price some 2 and some 3 so its not an efficient table (i set the values to 0 if not exist in the product).
following normalization i created new table with ID and Price Fields and deleted the prices fields from the Product table.
My dilema is when I insert many records (~100,000) using update batch it takes the table to be update few time more time then in the original form.
Is it worth it to do normalization in this case?