This example creates a named secondary index on a load isolated table that records the RowLoadID.
CREATE INDEX(dept_no) WITH LOAD IDENTITY ON employee;
This example creates a named secondary index on a load isolated table that does not use the RowLoadID:
CREATE INDEX(dept_no) WITH NO LOAD IDENTITY ON employee;