An index contains duplicate values, when at least one value occurs more than once in the index (and hence, in the column being indexed).
For an index defined on more than one column, an index value is considered duplicate only if all indexed fields of two or more rows of the table are completely identical.
A "unique" index disallows duplicate values. Disallowing duplicate values in a table column can only be enforced by creating a unique index on that column.
-- Peter.
|
DUPLICATE VALUES ?
