|
|
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
Navigation:
[Reply to this message]
|