can a index consist of 3 columns (Oracle newbie)

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/