This content has been marked as final. Show 2 replies
843178 wrote:That's an intersting piece of code.
-- *** Following line is included for faster performance
and hiroc_rpt_user.hiroc_get_delta_amount(pp.policy_fk, pp.policy_term_fk, pp.risk_fk, pp.coverage_fk, pp.transaction_log_fk, pp.coverage_component_code) != 0
Apparently, by adding a user defined function into a query, that's going to improve performance according to the comment.
In truth, it's going to add context switching and slow the query down.
As well as posting the information required (as detailed by the FAQ posts), you will also need to ensure you provide detials of what that function does. If the functionality can be done in SQL rather than a PL/SQL function, then that will certainly improve things.