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?