Reidy, Ron wrote:
Why don't you speak with the DBAs at your site? They can tell you
> what they want, and if it goes south, they will have themselves > to blame.
We have some ongoing dialogue. Mostly they want me to stop hammering their database. ;-) What seemed to work well was this: select the rows I want to keep into a new table; truncate the old table; drop the old table; rename the new table to the old; redo indices, etc. The part that surprised me was the truncate. Simply dropping a table without first truncating it seemed to take a lot longer. -- Steve Sapovits [EMAIL PROTECTED]
