kapil_kk (12/27/2013)
But if I add few column of non clustered index to unique constraint columns then also uniqueness will be retained.... so in that case can I go with this
Yes, and you'll end up with a redundant index and additional write overhead.
Once more with feeling....
Have you done performance tests? Is the performance of queries using this table inadequate? Is there a problem here at all?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability