How to Create an Index

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

create unique index emp_ix1 on employee ( employee_id );

create index emp_ix2 on employee ( last_name, start_date );