MS SQL Server Views Question: Download Questions PDF
Explain Indexed view?
![SQL Server Views Interview Answer SQL Server Views Interview Question](https://globalguideline.com/public/images/interview/30.png)
Answer:
An index view has a unique clustered index created on it. They exist as rows on the disk. Because they are saved on the disk, the response time to a query is fast at the cost of space consumption. They are more commonly used in scenarios when data modification is less.
Syntax:
Create Index CREATE [UNIQUE ] [ CLUSTERED | NONCLUSTERED ] INDEX index_name ON table_name
The view is created using the CREATE VIEW synatx
Syntax:
Create Index CREATE [UNIQUE ] [ CLUSTERED | NONCLUSTERED ] INDEX index_name ON table_name
The view is created using the CREATE VIEW synatx
Download SQL Server Views Interview Questions And Answers
PDF
Previous Question | Next Question |
Explain Partitioned view? | Explain the functionalities that views support? |