Can views be indexed ?

Published by: Rinku (8/29/2008)

I am confused. As per some textbook views can not be indexed as they are logical entities and dont contain any data. Some other refereces talk about indexed views. So can views be indexed ? If so how, and what are the advantages of indexed views ?

 

Most Popular Articles

• SQL Server 2008 Error: is not a valid login or you do not have permission
• Cannot start .aspx
• what is the difference between Text and String Data type in SQL Server
• Error: Microsoft OLE DB Provider for ODBC Drivers error '80004005'
• Why my MS SQL Server 2005 DSN Connection is not Working

what is the difference between SQL server 2000 and SQL Server 2005 >>