[EMAIL PROTECTED] wrote:
Yes. To get reasonable performance you will need to enclose the SELECT and all the individual DELETEs within a BEGIN...COMMIT.
Richard,
Won't this quickly run through the select and delete commands, so that the progress bar quickly reaches 100%, and then sit there for some time while the I/O is done during the commit?
Dennis Cote