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"