SQL Statements › CREATE INDEX › Processing › Example

Example

The following example creates an EMPLOYEE_INDEX index on table-name EMPLOYEES, column-name EMPNO.

 EXEC SQL
     CREATE INDEX EMPLOYEE_INDEX ON EMPLOYEES (EMPNO)
 END-EXEC