General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
I was just asking myself the same question. Having 5 different tables combined into a view seemd to take a bit long to run even though the execution was simple. I converted this to an SP and the resultant improvement in speed was quite noticeable.
>I understand that once a stored procedure is run, the execution plan is stored on the server, but I think I remember reading that this is not true for views. Does that mean that generally, a stored procedure that returns a result set the same as a view will be faster than a view?
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only