6 Replies Latest reply: Jun 2, 2014 1:23 PM by Eduardo Pinhata RSS

    Performance question



      I have a company database with it's sales in fact table (date of sale, number of product, name of product, quantity, revenue, etc). There is above a picture of it's model.



      Now, I need to insert a plan table, where I have the product key with it planned sales quantity and revenue. What's better:


      1) I create another table and link it with the fact table.

      2) Insert another column in the fact table and join this new information with the fact table. (All the other information in these rows with the planned information will have null value.)

      3) Other option that I don't thought.