How to Create an Index

To create an index you need to use the create index statement specifying the name of the table, the name of the index and the columns forming the index key. Additionally you can specify if the index allows duplicated or unique keys.

create unique index emp_ix1 on employee ( employee_id );

create duplicate index emp_ix2 on employee ( last_name, start_date );