• A Clustered Index doesnt need to be unqiue, in fact the only case where you have to have the Unique index (to my knowledge) is on a PK which by default shuold be unique.

    I'm never sure about partitioned tables and clustered Index, Instinct tells me to use the column that is specified in the Partition schema as the Primary column on the cusltered index as, with all other columns in the index as subordinates, but I might be wrong on this, please correct me.

    _________________________________________________________________________
    SSC Guide to Posting and Best Practices