I wanted to create clustered index on view in order to obtain materialized view. Unfortunately the option to create index on view is disabled (faded). Do you know why?
I am using Microsoft SQL Server 2014 Express.
All the best Bartosz Siemasz
Asked
Active
Viewed 243 times
0
-
1Have you tried running it as a script? If so what is the error message returning? – Zi0n1 Aug 19 '16 at 18:55
-
If you like [at the feature comparison](https://msdn.microsoft.com/en-gb/library/cc645993(v=sql.110).aspx), I don't think Express editions support indexed views – marc_s Aug 19 '16 at 19:29
-
I will try to run it as a script. – Bartosz Siemasz Aug 19 '16 at 20:56