The following restrictions apply to CMP.
You can drop CMP indexes.
CMP indexes cannot be unique.
An exception is raised if you attempt to alter or delete a column that is defined in a CMP index.
You cannot ALTER TABLE MODIFY an existing column that is defined in a CMP index.
CMP indexes do not support the BIT, FLOAT, DOUBLE, and REAL data types.