Indexed views

Hi Jayachandra,

Views are also known as virtual tables because the result set returned by the view has the same general form as a table with columns and rows, and views can be referenced just like tables in SQL statements. The result set of a standard view is not stored permanently in the database.

The first index created on a view must be a unique clustered index. After the unique clustered index has been created, you can create more nonclustered indexes. Creating a unique clustered index on a view improves query performance because the view is stored in the database in the same way a table with a clustered index is stored.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nishant Mittal10y ago
Hi Raja,

First understand the concept of views if you are not aware :)

Views basically encapsulated the multi table query logic in that.

We can add cluster index on the views as well.Index view is used when u need to perform complex logic etc.

Read this :
https://www.simple-talk.com/sql/learn-sql-server/sql-server-indexed-views-the-basics/
Raja T10y ago
Hi Jayachandra,

Views are also known as virtual tables because the result set returned by the view has the same general form as a table with columns and rows, and views can be referenced just like tables in SQL statements. The result set of a standard view is not stored permanently in the database.

The first index created on a view must be a unique clustered index. After the unique clustered index has been created, you can create more nonclustered indexes. Creating a unique clustered index on a view improves query performance because the view is stored in the database in the same way a table with a clustered index is stored.

More details check out below links

https://www.simple-talk.com/sql/learn-sql-server/sql-server-indexed-views-the-basics/

http://blog.sqlauthority.com/2010/10/12/sql-server-indexed-view-always-use-index-on-index/

http://www.codeproject.com/Articles/199058/SQL-Server-Indexed-Views-Speed-Up-Your-Select-Quer