Archives

DROP INDEX index_name ON tbl_name DROP INDEX drops the index named index_name from the table tbl_name. After deleting the index on ‘gender’ column, the performance enhancement is lost.