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]

Reply via email to