Question
2
Replies
510
Views
Posted: December 18, 2016
Last activity: December 20, 2016
Closed
Defining relationships between tables in reports
With reference to performance point of view - What is best option to be used for defining relationships between tables in reports (Using join or association)?
Moderation Team has archived post,
Close popover
This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 4 years ago
From the Help page for 7.1.7 (I believe this applies to all versions of PRPC):
Associations are predefined SQL JOIN operations.
So I don't believe there is any performance difference between a class join and an association. The association rule is simply a convenience feature for defining a commonly used class join that is inherited by the descendants of the applies to class.
I'm not sure there would be any difference between the two from a performance standpoint. I have not dealt with associations, but they seem like they are convenience objects for commonly used joins to other classes.
The way to determine for sure is to see what SQL is generated for a class join versus the equivalent association (e.g., create 2 reports, turn on DB Query events, and trace both). If the SQL is the same, then there is no performance difference. If the SQL is different, you can get an explain plan for each query to find out which is more efficient.