The number of unique values in a query may cause issues.
1009103: Number of unique values exceeded for index. index_name_LF 10000The Low_Fast index is optimized for 1000 unique values, but has an upper limit of 10000.
Replace the LF index with an HG index. 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)