"CMP index can only be created on two distinct columns having identical datatypes. %1"
Probable cause
A CMP index is an index that can be only created on two columns. You cannot create a single column CMP index; nor can you create a CMP index on three or more columns. Furthermore, when specifying two columns, the two columns must have identical datatypes.