what is difference between unique index and unique constraints in table column ? in the statement below, what is meaning of "self-documenting" ?
UNIQUE constraint is more self-documenting within the database. That being said, Oracle Corporation formally recommends the creation of unique indexes to enforce uniqueness in a column, for better results in query performance