jeff wrote:
The rollback issue will not disappear. IIRC, Autocommit simply issues a commit at the end of the transaction (delete) without you having to do it explicitly.
So that makes the simple DELETE/WHERE method of deleting rows no good for large row sets where rollback space is limited, correct? I guess next best is to try one of the other methods: Break it into deletes of smaller row sets or create a new table from a query and replace the old with the new. -- Steve Sapovits [EMAIL PROTECTED]
