ER - Join VS relation

(1) Share

Report

Posted on by Pranav Teja

201

hi Experts,

Can anyone clarify the advantage of using join.

Taking an example of dumping all purchase order lines with a couple of fields from PO header, we can very go to relations of Purchline and navigate to Purchtable to map those fields.

Pranav

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

CA Neeraj Kumar 4,364 on at

Like (0)

Report

ER - Join VS relation

Hi Pranav,

When you use join, it run at SQL query level which is much faster than using the relations. I have explained the same in one of my video (at present it is kept under membership by the owner - https://youtu.be/74xwJNqXlMM?si=oQenGT_nHmokf77j

So, it is always preferrable to use Join to maximum extend and ensure that it is runninn in SQL level rather than memory. You can refer this article as well to understand the difference between memory and SQL query level. https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/er-calculated-field-ds-performance?context=%2Fdynamics365%2Fcontext%2Fcommerce

In case of further query, please us know,

Regards,

Neeraj Kumar

Author of the Book - Electronic reporting - The Hidden Gem

Was this reply helpful? Yes No