General information
Title:
Want to Reduce Execution Time
Hi,
I have written some Stored Proc in ORACLE for making some calculations, in that i am invoking CURSORs for LOOPing.
It takes more than 30 mins (1/2 hr) to excute the PROCEDURE for less than 700 records.
I have tried to reduced the execution time by making the INDEX on the tables, but that also doesn't work.
How should i reduced the execution time in procedures.
Thanx in advance,
Amol
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only