about "Oracle recommends that unique indexes be created explicitly"

From: qihua wu <wqhhp_at_yahoo.com>
Date: Fri, 30 Jun 2006 01:44:55 -0700 (PDT)
Message-ID: <20060630084455.18005.qmail@web61211.mail.yahoo.com>

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.
--

http://www.freelists.org/webpage/oracle-l Received on Fri Jun 30 2006 - 03:44:55 CDT