I am trying to delete 20000 rows from a table (which has appx 25000 rows). But it is taking 30 minutes to delete the rows! It is a development database and no other activity is going on the table.

Any idea what went wrong.

I used this query

DELETE FROM PRODUCT WHERE PRODCODE LIKE '99%' AND LENGTH(PRODCODE)=7