Can you explain What is Indexed view? How to create it?
Submitted by: AdministratorIn 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]
Submitted by: Administrator
CREATE [UNIQUE], [CLUSTERED | NONCLUSTERED] INDEX index_name
ON {view}
[WITH <index_option>]
[ON filegrp]
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. |
