-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
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.
- Can MaxDB use index in delete statement? Alexey Gaidukov
- RE: Can MaxDB use index in delete statement? Becker, Holger
- Re: Can MaxDB use index in delete statement? Alexey Gaidukov
- Re: Can MaxDB use index in delete statement? Alexey Gaidukov
- Compile DBPROC error message if there is statemen... Alexey Gaidukov
- RE: Can MaxDB use index in delete statement? Becker, Holger
- RE: Can MaxDB use index in delete statement? Becker, Holger