Hey Michael -- on this same subject, can't you index a view? I thought that was one of the benefits of using it over a function...


>>>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