Yggaz (12/19/2012)
Lokesh Vij (12/19/2012) Ideally, both Unique constraint and Unique index are same as Unique Constraint creates Unique Index to maintain the constraint to prevent duplicate keys.
They are definitely not. Every unique constraint has a corresponded unique index and operates via it. But the opposite is not true: you can have unique index without unique constraint.
Agreed!
I am trying to keep Qotd Author's perspective. As in "Ideal" case both Unique Constraint and Unique index helps us to yield same DB integrity rule - "Unique Records".
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter