SQL Statements › CREATE INDEX › Example
The following example creates an EMPLOYEE_INDEX index on table-name EMPLOYEES, column-name EMPNO.
CREATE INDEX EMPLOYEE_INDEX ON EMPLOYEES (EMPNO)