• Thanks for your quick replay.

    uniqueidentifier column(with primary key (now)) has been used in table joining in current design.

    so if i remove the current primary key on uniqueidentifier, will the join perfomace degrade or grade(improve).