Posted by Frank Villasenor on 10/01/41 11:42

Hello Everyone,
Regarding stored procedures and views, I know that stored procedures
cause SQL Server to create a cached execution plan. Is the same thing
done for views? Also, how bad is the performance hit for a stored
procedure that use 1 or a few views as opposed to re-creating the same
select statement with the proper joins to the required tables?

I know that there are a bunch of variables that affect this stuff, I
just trying to get a ball park idea of how this stuff works.

Thanks,
Frank

[Back to original message]