CREATE INDEX examples

The following statement creates an index on a DBF table:

CREATE INDEX NAMEX ON employee.dbf (LAST_NAME)

The following statement adds an index called ZIP on the ZIP_POSTAL column of the CUSTOMER table:

CREATE INDEX ZIP ON CUSTOMER (ZIP_POSTAL)