Please help me with Syntax of all forms of Altering SECONDARY index .
Thanks in Advance!
The only index that you can modify using an alter is the primary index and the table must be empty to do that.
ALTER TABLE HSTLD.ADW_CUSTOMER_TYPE2 MODIFY PRIMARY INDEX(CT_ID );
Dieter has provided the only approach for modifying secondary indexes.