I'd like to know difference in performance between display_journal and R4I UDTF. If using R4I UDTF how much will performance improve from using display_journal.
For DISPLAY_JOURNAL, it retrieves a broader range of journal entries first, and then filters them using SQL WHERE clauses. In contrast, R4I UDTF performs filtering at the source level before generating the result set. This explains why R4I UDTF delivers much better performance.
However, it is hard to quantify the exact performance improvement because it depends on the distribution of changes. For example, if we only need to retrieve 1 target record out of 1 million total journal changes, R4I UDTF will be significantly faster since it eliminates the massive overhead of checking those 1 million records through SQL clauses.
Regards, Desmond
Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
For DISPLAY_JOURNAL, it retrieves a broader range of journal entries first, and then filters them using SQL WHERE clauses. In contrast, R4I UDTF performs filtering at the source level before generating the result set. This explains why R4I UDTF delivers much better performance.
However, it is hard to quantify the exact performance improvement because it depends on the distribution of changes. For example, if we only need to retrieve 1 target record out of 1 million total journal changes, R4I UDTF will be significantly faster since it eliminates the massive overhead of checking those 1 million records through SQL clauses.
Regards, Desmond
Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
