Explain Indexed view?
Submitted by: AdministratorAn 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
Submitted by: Administrator
Syntax:
Create Index CREATE [UNIQUE ] [ CLUSTERED | NONCLUSTERED ] INDEX index_name ON table_name
The view is created using the CREATE VIEW synatx
Submitted by: Administrator
Read Online MS SQL Server Views Job Interview Questions And Answers
Top MS SQL Server Views Questions
| ☺ | Explain Indexed view? |
| ☺ | What are views? |
| ☺ | Explain the functionalities that views support? |
| ☺ | Can you explain What is Indexed view? How to create it? |
| ☺ | Explain What are partitioned views and distributed partitioned views? |
Top New MS SQL Server Categories
| ☺ | SQL Server Database Administrator Interview Questions. |
| ☺ | SQL Server Service Broker Interview Questions. |
| ☺ | SQL Server Locks Interview Questions. |
| ☺ | SQL Server Constraints Interview Questions. |
| ☺ | MS SQL Data Mining Interview Questions. |
