Indexed View can’t create online in the beginning.

Posted by Simon Cho on 03/08/2018

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

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

This entry was posted on 03/08/2018 at 2:31 PM and is filed under Common. Tagged: Indexed View, Online Index. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Enter your comment here...

Fill in your details below or click an icon to log in:

Email (Address never made public)

Name

Website

You are commenting using your WordPress.com account. ( Log Out / Change )

You are commenting using your Twitter account. ( Log Out / Change )

You are commenting using your Facebook account. ( Log Out / Change )

Connecting to %s

	Simon Cho on PASS Summit 2019 – Datab…
	Anonymous on understading status column of…
	BestRaymond on How to troubleshoot the…
	Simon Cho on Between 4096 and 512 sector si…
	Kevin Ojunta on Between 4096 and 512 sector si…

Simon's SQL