Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Views vs Stored Procedures
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00690479
Message ID:
00690508
Vues:
9
>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform