1 Reply Latest reply: Dec 1, 2010 4:13 AM by Rob Wunderlich RSS

    normalize or not?

      Hi!

      I have a excel file with a lot of sales data. Each row contains information of customer, date, referens and so on.

      My question is if I should divide the table into several tables through the script so that I get a customer table, an order table, un order row table.

      If I do it in SQL I would and then use JOIN

        • normalize or not?
          Rob Wunderlich

          The quick answer is no. In general, QV works best with denormalized data. There are exceptions of course. But the typical reasons for normalization -- space savings, referential integrity, etc -- don't usually apply to QV. So leave it denormalized as is.

          -Rob