Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Views vs Stored Procedures
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00690479
Message ID:
00690508
Views:
10
>>Im wondering if anyone uses views?

Sometimes

>> Are they as fast as using a stored procedure and passing in the values for the where clause? Are the execution plans for views stored like sp's.

No. SQL Server does not store a Query Plan for a view.

>> I can't find much info on views other than you can treat them like regular tables.

Think if a view as a stored query definition. When you include a view in the FROM clause of a query, SQL Server will take the definition of the view and merge it with your query. The resultant query is then processed like any ad-hoc query.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform