Thanks for your reply. Sorry for not providing the complete information. So this is how the table relationship is .

Product master---= product price -->order.

The order and the product price are linked with the order I'd and the product price and product master are linked by the product master key. The sql profiler shows performance issue when I try to run the report by product number,product price ,sum of sales. When I add the product price my performance get hit if the data is huge for the order table

The order table holds daily transaction.