5
Database Administration
Call Data Tables
UCS 1000 R4.2 Administration 585-313-507
Issue 3 April 2000 212
4
Enter
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
:
1
At the
Console Login:
prompt, enter root
The system prompts you for a password.
2
Enter your root password.
The system displays the system prompt
#
.
3
Enter sqlplus sti/sti
The system starts a sqlplus session.
4
Enter create index index_name on table_name (“FIELD1”);
The system creates a non-unique index for FIELD1 in the table.
