Avatar

Simon's SQL

DevOps, Kubernetes, AI/ML and database platform notes from Simon Cho — AVP of DevOps & DBA at Nowcom, PASS Summit speaker.

  1. Home
  2. About
  3. Talks
  4. Archives
  5. Search
    1. Dark Mode
Performance & Tuning

Indexed View can’t create online in the beginning.

Mar 8, 2018 1 minute read

https://docs.microsoft.com/en-us/sql/relational-databases/indexes/guidelines-for-online-index-operations

Initial unique clustered index on a view is exclusive from Online Index operation.

However, unique clustered index is very required for indexed view.

Indexed View Online Index
Share LinkedIn X Facebook

Related content

Update statistics blocking issue(Part 1)

Delayed Durability

parameter sniffing recompile options

SQL Server Column store row group investigation

Memory troubleshooting

© 2011 - 2026 Simon Cho
Simon Cho · simon@simonsql.com
Built with Hugo
Theme Stack designed by Jimmy