Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

about "Oracle recommends that unique indexes be created explicitly"

qihua wu

2006-06-30


The book of "oracle concept" says
 
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.
 
So under what condition will the created index through primary key or unique constraint not be a unique index?
 


How low will we go? Check out Yahoo! Messenger?s low PC-to-Phone call rates.
©2008 dba.5341.com - Jax Systems, LLC, U.S.A.