Subject Re: Why did a large delete make a table partially inaccessible
Author Matt Clark
--- In, "Ann W. Harrison"
<aharrison@...> wrote:

> However, if you can drop the table (meaning there aren't procedures
> and views nested six levels deep that depend on it), you'll find
> that copying the 2 million records you want to a temporary table,
> dropping the primary table, then recreating it, reloading the data,
> then recreating the indexes is much faster than deleting 18 million
> rows.
> Good luck,
> Ann
Thanks Ann, I'm likely to be doing similar things again soon so I
don't want to hit the same problem. Our database is getting growing
pains at the minute (more on that later!) so I'm looking for more fat
to trim.