Procedure tuning
535089Feb 7 2007 — edited Feb 8 2007Hi All,
I am given a procedure to be tuned for performance which currently takes around 4 hours to run(runs as a job) and needs to be reduced to less than an hour. It selects, inserts and updates to more than 25 tables. But Almost all the select, insert and update statements involve single table. Below is a sample statement. Like this there are more than 100 statements. So I think much cannot be done with Explain plan. So please give me an idea on how to proceed with the fine tuning such as creation/removal of index etc ?
CURSOR Cur_web(No IN VARCHAR2) ISSELECT *FROM web_appWHERE applicant_no = NoAND refree_type = 'REL';