emp table is PARTITION BY HASH (emp_no) PARTITIONS 100 and the table has 100 million rows.
The following delete takes a long time. I think it is accessing all the 100 partitions. So how to make the delete faster in this case? That may be the problem with HASH partition itself. Thanks.
Delete from emp table where year =2008 and month =1