-
20,000 row delete takes 30 minutes! Why?
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|