slow execution of procedure

[prakashroch]

i have a stored procedure which creates a temporary table the table has 5 columns ....since all the 5 columns have a different where clause i have 5 different update statements which update the columns. .the problem is the stored procedure is running extremely slow …..the table holds approx 2000 records …….i removed the updates and it runs fast …also as the records increases the execution time increases i came to a conclusion that update is making my procedure slow…….is there any way out … any suggestions

 

[dbtech]

Please post your code and sample data to run the stored procedure.



dbtech