Re: Newbie question

From: L120bj <l120bj_at_aol.com>
Date: 2000/05/30
Message-ID: <20000530161459.18915.00000701@ng-cs1.aol.com>#1/1

>How can I index a column which has duplicates ,without having to combine the
>column with another to create composite primary key,
>

Just use
create index <index name> on <table_name>(<column_name>) tablespace <tablespace_name>
storage (<storage_clause>).
HTH,
Rob Received on Tue May 30 2000 - 00:00:00 CDT