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?
Chris McCandless
Red Sky Software