Normalization for Performace (revised)
Perhaps this is heresy. Perhaps it merely shows that the orthodox may be focused on short-term delivery, not long-term value.
CONTEXT AND PROBLEM
The client has a table we could describe as following the M.E.S.S. -- Multiple Entity Sub-Species -- design pattern. The hallmarks of this design are a …