GilaMonster (2/18/2014)
Why clustered? This isn't typically where you would put the clustered index.
not clustered isn't a sensible option - a view has to have a clustered unique index before it can have a non-clustered index, and as there's only one column in this view that first index does the job and there's no point in adding a non-clustered index.
And in a one colum view, how can this not be typically where you would put the clustered index?
edit:typos
Tom