Answers

Question and Answer:

  Home  SQL Server Views

⟩ Can you explain What is Indexed view? How to create it?

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]

 143 views

More Questions for you: