Indexed View must contain a clustered index.
TOC
Collapse the table of content
Expand the table of content
The document is archived and information here might be outdated

Indexed View must contain a clustered index.

Because an indexed view is stored on disk, it must contain a clustered index (rather than a nonclustered one). Modify the index to make it a clustered index.

Show:
© 2016 Microsoft