Create Index on Code Column

You need to create a unique index on the alphanumeric code column if an index does not exist. While creating index, you need to ensure that the index uniqueness should be case insensitive.

Example:

Create unique index IDX1_DIM_PRODUCTS_B on DIM_PRODUCTS_B Upper(PRODUCT_CODE)

Commit;