We have 7 navigational attributes 7 variables on these navigational attributes and we need to add 2 additional navigational attributes and 2 variables on these navigational attribute. We already have 22 variables on Charateristics. I need to analyse the effect of
1. New variables on the query performance(total 29 variables are present).
2.New Navigational attributes on query performance.
2.New Navigational attributes on loading.
I know
Navigation attributes are joins that need to be performed at query execution at the time of drilling down.
Joins at runtime for query generation are very expensive and should be minimized
I need some data to present. Kindly convey the way to do so.