Friday, July 16, 2010

Increasing Performance in cursor

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: