2 ms·
If I understood it correctly, the GP is talking about those normalized tables: U | X X | Y and claiming that if you need the relations of U | Y often, you ar
by marcosdumay 3y ago
If I understood it correctly, the GP is talking about those normalized tables:
U | X
X | Y
and claiming that if you need the relations of U | Y often, you are better storing them as:
U | X
U | X | Y
Or just the later table, since the first is now completely redundant.
So yes, that happens, and depending on the size of those tables, it may be true that the denormalized for is faster. But it's just wrong to claim that one or the other is faster without any further information, and IMO, the more common case is that the normalized one is faster.