Last post Dec 16, 2014 10:36 PM by Edwin Guru Singh
Dec 16, 2014 07:44 AM|Nishantg|LINK
I am using one procedure which is populating sample data by inserting in various table. This procedure is calling other procedures also. I wanted to know how I can improve the performance of this procedure. I can't use execution plan as I am using number
of temp table for manipulating the data. I tried to disable the Foreign key to improve the performance but it doesn't seems to work, please do let me know if someone have any idea.
Thanks in advance.
Dec 16, 2014 10:36 PM|Edwin Guru Singh|LINK
As per your case, the following steps will be useful to improve performance, tuning & optimizing in Stored procedure as :
Hopefully this will be helpful for you.