Deletes one or more index definitions. When the DELETE INDEX
    statement executes, Oracle Rdb deletes the index definition from the
    physical database. If you invoke the database using the PATHNAME
    argument, Oracle Rdb also deletes the index definition from the data
    dictionary.

    Example:

    DELETE INDEX EMP_LAST_NAME.