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.
Submit feedback about this site to: