Stored Proc vs Inline Queries

Question

Stored Proc vs Inline Queries

GonnaCatchIT

SSCrazy

Points: 2797
More actions
June 24, 2015 at 9:29 am

#305333

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?.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

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