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.