Duplicate Tables? Modelling Advice

[karimabdelrazek]

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 practice or not. (B) does it create problems later on? (C) when should I actually use it.

Just for context, the tables I am looking to duplicate are not very large and are not expected to accumulate an "exorbitant" number of records over time.

Any advice would be highly appreciated!

Thanks!

Karim

[karimabdelrazek]

@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. 

[Fowmy · Accepted solution]

@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.