Load Fails on Number of Unique Values

The number of unique values in a query may cause issues.

Possible Cause

The following message in the log file indicates that you have more than 10000 unique values in a column with an LF index:

1009103: Number of unique values exceeded for index.
index_name_LF 10000

The Low_Fast index is optimized for 1000 unique values, but has an upper limit of 10000.

Replace the LF index with an HG index.

To do this, issue a DROP INDEX statement to drop the LF index identified in the error message. For example:

DROP INDEX DBA.employee.emp_lname_LF

Then issue a CREATE INDEX statement to create the new HG index. For example:

CREATE HG INDEX ON DBA.employee (emp_lname)