Re: unique contraint without index

On Jan 16, 2:03 pm, "oracle dba" <aoracle..._at_gmail.com> wrote:
> Taral wrote:
> > Yes, you can create unique constraint on this two column and will not
> > create unique index
>
> > ALTER TABLE table_name
> > add CONSTRAINT constraint_name UNIQUE (column1, column2, ... column_n);
>
> > On Jan 16, 12:07 pm, "oracle dba" <aoracle..._at_gmail.com> wrote:
> > > 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.Is this possible for primary key without index.

A primary key without any index just doesn't make sense. Nor does your nick.

-- 
Sybrand Bakker
Senior Oracle DBA