Why we have to first create Unique Clustured index on view ?

1.The index has to be unique to allow easy look up of records.

2.Prevention from creating duplicate indexes.

3.The index must be clustured index because only clustured index can enforce uniqueness and store the rows at the same time.

Pawan Kumar
Pawankkmr@hotmail.com

Advertisements