Here is an SQL query to alter an index in DB2. When to drop the index and when not required while altering the index, added guidelines for your reference.