pros and cons

  • From: Sai Selvaganesan <ssaisundar@xxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 30 Mar 2004 14:50:08 -0800 (PST)

hi
 
i read the follwing line in oracle 9i documentation,
 
Unique and primary keys can use non-unique as well as unique indexes. They can 
even use just the first few columns of non-unique indexes. 
 
i am planning to use a primary key constraint enforced by the first few columns 
of a non-unique index.any feedback or advice or gotchas in having such a setup.
 
thanks
sai

Other related posts: