June 24, 2015 at 9:29 am
Hi ,
We have a performance issue on one of the queries. We have observed some potential improvements in the queries. Currently its an inline query in the .net code.
My question: Moving the as is inline query to a SP will help in any performance gains?.
June 24, 2015 at 11:55 am
It depends. Just changing the inline query into a stored procedure likely won't improve performance, but having the query in an stored procedure does make tuning the query easier because you do not have to change the application in order to change the query to one that performs better.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy