MS SQL Server Views Question: Download SQL Server Views PDF
Can you explain What is Indexed view? How to create it?
Answer:
In an indexed view, the data is already computed and stored. Data can be accessed by a unique index. This index is a clustered index. In order to create an index the syntax is
CREATE [UNIQUE], [CLUSTERED | NONCLUSTERED] INDEX index_name
ON {view}
[WITH <index_option>]
[ON filegrp]
CREATE [UNIQUE], [CLUSTERED | NONCLUSTERED] INDEX index_name
ON {view}
[WITH <index_option>]
[ON filegrp]
| Previous Question | Next Question |
| Do you know what are the restrictions that views have to follow? | Explain What are partitioned views and distributed partitioned views? |