Insert into :Performance issue | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Insert into :Performance issue

Hi, I have a insert into statement in sp1 which executes sp2.sp2 retuns around 2000 rows after lot of processing.When I execute sp2 directly from query analyser it takes about 2-3 mins but if I do the
insert into tab1
exec sp2 It takes 20 mins. what are my other options, how can i improve the performance? Thanks,
Dear Friend Posting the code of SP1 and SP2 will be of lot help in analyzing the situation Anil Never Give Up
Also check the execution plan for the referred stored procedures, by clearing the cache for optimum execution. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.