Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: can a index consist of 3 columns (Oracle newbie)
create unique index pk_article on article(entity_code, version_index,sector_code)
Hth,
Sybrand Bakker, Oracle DBA
"mr_oatmeal" <mr_oatmeal_at_hotmail.com> wrote in message
news:ssd5rebkqldp14_at_corp.supernews.com...
> Hey All,
>
> We don't have a DBA here, so i've been trying to figure things out on my
> own....
>
> I need to add an index to a table--article. In order to find a unique row
> you have to query based on 3 columns (entity_code, version_index,
> sector_code), all of them are varchar2. What would be the best way to
> index this table. The table has about 100,000 rows.
>
>
> table: article
>
> entity_code varchar2
> version_index varchar2
> sector_code varchar2
> other_column
> other_column
>
> Thanks,
> mr_oatmeal
>
>
>
>
> --
> Posted via CNET Help.com
> http://www.help.com/
Received on Mon Sep 18 2000 - 23:49:21 CDT