Unique and Nonunique Indexes (195)

Indexes can be unique or nonunique. Unique indexes guarantee that no two rows of a
table have duplicate values in the key column (or columns). Nonunique indexes do
not impose this restriction on the column values.
Oracle recommends that unique indexes be created explicitly, using CREATE UNIQUE
INDEX. Creating unique indexes through a primary key or unique constraint is not
guaranteed to create a new index, and the index they create is not guaranteed to be a
unique index.

唯一索引和非唯一索引
1. 在一個表上建立唯一索引能夠保證此表的索引列不存在重複值.
2. Oracle 建議使用 CREATE UNIQUE INDEX 語句顯式地建立唯一索引.

[@more@]