Drop index oracle

Drop index oracle example

You can remove unnecessary indexes from oracle database using pl/sql command drop index.

Syntax:

DROP INDEX index_name;

Example:

  

-- drop index
DROP INDEX AMOUNT_IDX;

Output:

index AMOUNT_IDX dropped.