If table EMP has 30 millions of rows, what is the fastest way to delete? Will index on DEPT_NO make it faster? Is there a hint like DELETE /*unrecoverable*/ to make the delete faster? Right now, the delete of 1 million rows takes a few minutes. Thanks!
DELETE FROM EMP WHERE DEPT_NO =10;