Performance issue
Below procedure takes 20-30 min sometimes much time to execute,
Please help on this to improve performance
Table Count for VENDOR_ASSIGN_MATRIX :1065
Count for cust_acct : 556114
Count for Cust_acct_rel : 894232
create or replace
PROCEDURE vendor_auto_assign (
v_repoagent IN VARCHAR2 DEFAULT '',
v_userid IN VARCHAR2 DEFAULT '',
v_computerid IN VARCHAR2 DEFAULT ''
)
AS
v_vnr_cnt NUMBER := 0;
v_ven1_per NUMBER := 0;
v_ven2_per NUMBER := 0;
v_ven3_per NUMBER := 0;
v_ven4_per NUMBER := 0;
v_rec_cnt NUMBER := 0;
v_first_ins NUMBER := 0;
v_sec_ins NUMBER := 0;
v_third_ins NUMBER := 0;
v_four_ins NUMBER := 0;
v_errcode NUMBER := 0;