• 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