I have table with 2 millions records. I have a field with index. Simple statement: "select * from table where field in (1,2,3)" performs very fast. But the statement "delete from table where field in (1,2,3)" takes about 15 minutes. What is wrong? I'm using MaxDB alone so thare aren't any locks.

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to