--- In firebird-support@yahoogroups.com, "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.

Regards,
Matt