Question
2
Replies
505
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)?
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.