Best Architecture Question...

[hogmahub]

I have a large SP which has to calculate a large P&L on the fly. It is key that this works very quickly and as such which is the best architecture for speed:

Table One:

Sku Value1 Value2
0120 20 Brand1
0121 20 Brand1
0121 20 Brand1


obviously this table can be normalised further, but if I add an extra table and outer join to all SQL statements in the SP will it be any quicker?

Thanks

Ian

[hogmahub]

To clarify, what I'm really asking is ...


does searching through 3 times the number of records have more overhead than searching through unique records and adding an outer join to every SQL statement in the SP to link into the normalised sku table?

Thanks