Home > IT Answers > SQL Server > optimization of stored procedures in sqlserve...
Naresh1226
5 pts.
0
Q:
optimization of stored procedures in sqlserver
Stored Procedures, SQL Server stored procedures, Stored Procedures Optimization
is there any stored procedure optimization techniques
actually my problem is
my stored procedure is getting information from 15 tables by joins and have some conditions in where clause

to get 15,000 records it is taking 40 sec

how can i improve the my stored procedure

thanks,
naresh
ASKED: Apr 16 2009  6:15 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Carlosdl
29340 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
The first thing I would do is identify the commands that are taking longer to execute inside the procedure.

Once identified, I would have a look at the execution plans of those commands to see if the problem could be the lack of one or more indexes
Last Answered: Apr 16 2009  2:10 PM GMT by Carlosdl   29340 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0