Msg#: 4105703 posted 2:54 pm on Mar 27, 2010 (gmt 0)
VIEWS are not temp tables, they are stored SELECT statements. Think of them as virtual tables.
When you reference a view, the stored select statement is executed. Views allow you to create complex queries that you can treat as a table. The underlying data remains in the tables referenced in the view definition. Indexes for those tables are still utilized.