Nov 24, 2021
Instead of normalizing the data set isn't it better to denormalize it? Though redundant but helps improve the cost and speeds up the query as less joins are needed because most of the information is available in the same table
Example Order table with item and price details along with country and item category all in one table.