Forum Discussion
Solved
Duplicate Tables? Modelling Advice
Hi, I'm a newbie at this. My data model is becoming very large and very complex. I recently "discovered" duplicating tables. It solves a number of problems for me but not sure if (A) this is good pr...
karimabdelrazek
I am not sure what you mean by duplicating tables in your context. In general, more tables would increase your model size and create performance hits unless you author your measures carefully. When you say complex, it si so general and you need to provide more details and context as to where the complexity exists.
Fowmy thank you for your feedback. Believe it or not, your reply has actually prompted me to revisit my data structure and therefore my table structure as well. I did find a few opportunities to further simplify the model and am doing that at the moment. I think copying the data tables was more of a "lazy approach" on my part as opposed to rethinking and optimizing.