Skip to Content
0
Former Member
Jan 08, 2008 at 02:00 PM

Effect of query perfomance on Variables on Navigational Attributes

27 Views

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.