The following request drop the definition of the join index named ji_emp from the data dictionary. DROP JOIN INDEX ji_emp;