Asterisk (*) may not be used in an indexed view.
Because an indexed view is stored on disk, the view definition must explicitly refer to the columns to be included in the view. Replace the asterisk with the columns you want to include in the view.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Because an indexed view is stored on disk, the view definition must explicitly refer to the columns to be included in the view. Replace the asterisk with the columns you want to include in the view.