Hi,
Combing two tables in to a single table will give better performance or the Keeping it as two different tables and linking it will give the better performance irrespective of the data size.
I understand combing it as a single table or keeping it as a two tables is depend on number of analysis is made.
What are the factors to be considered while creating the data modelling other than the number of analysis.
1. Combine into a single table or keep it as two different tables.
2. Is there any impact on using the inline table
3. Data Islands issue.