about "Oracle recommends that unique indexes be created explicitly"
- From: qihua wu <wqhhp@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 30 Jun 2006 01:44:55 -0700 (PDT)
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.
Other related posts:
- » about "Oracle recommends that unique indexes be created explicitly"