Re: unique contraint without index

From: oracle dba <aoracledba_at_gmail.com>
Date: 16 Jan 2007 05:03:47 -0800
Message-ID: <1168952627.608588.321950@l53g2000cwa.googlegroups.com>

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. Received on Tue Jan 16 2007 - 07:03:47 CST