To increase the performance in the cursor use below statement in the cursor
/*+PARALLEL(OL, 10) */
CURSOR cur_month_usage
IS
SELECT /*+PARALLEL(OL, 10) */
ol.sold_to_org_id,
(SELECT hc.account_number
FROM apps.hz_cust_accounts hc
WHERE 1 = 1
AND hc.cust_account_id = ol.sold_to_org_id)
No comments:
Post a Comment