HP R4.2 index_name, table_name, index_name, table_name

5 Database Administration Call Data Tables

4Enter

create unique index index_name on table_name (“FIELD1”); The system creates a unique index for FIELD1 in the table.

Non-Unique Indexes

Non-unique indexes do not prevent the same data from appearing in that field in several records in the same table. For example, if a field contains the area code of a telephone number and an index is created for that field, it must be a non-unique index since other records may require the same number in their area code field.

Use the following procedure to create non-unique indexes on fields called FIELD1 and FIELD2 in a table called table_name:

1At the Console Login: prompt, enter root The system prompts you for a password.

2Enter your root password.

The system displays the system prompt #.

3Enter sqlplus sti/sti

The system starts a sqlplus session.

4Enter create index index_name on table_name (“FIELD1”); The system creates a non-unique index for FIELD1 in the table.

UCS 1000 R4.2 Administration 585-313-507 Issue 3 April 2000 212