How to delete an index on a table in DB2?

To delete indexes from a table in DB2, you can use the following SQL statement:

DROP INDEX index_name;

index_name is the name of the index to be deleted. After executing the above SQL statement, the index of the table will be removed. Please note that deleting an index may affect query performance, so make sure to understand the potential implications before deleting the index.