Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> unique contraint without index

unique contraint without index

From: oracle dba <aoracledba_at_gmail.com>
Date: 15 Jan 2007 23:07:43 -0800
Message-ID: <1168931263.901022.94170@l53g2000cwa.googlegroups.com> 





hi all,


In my database I don't want any index on three columns (a,b and c) I
need unique contraint on three columns, so that value will not repeat.
Is it possible.


And if no, then unique key is better or primary key for space usage
prospective. Or if YES then pls tell me how.
Received on Tue Jan 16 2007 - 01:07:43 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US