Subject Re: [firebird-support] MASSIVE DELETIONS
Author Ann W. Harrison
Puigsegur, Jordi wrote:
> Which is the best way to perform a massive deletion on a table with
> million of rows ?
> In other environments we first perfom a select to gather the dbkeys of
> the records to be deleted and then delete them performing commits every
> n records. Is there something similar in Firebird ?

What really helps with massive deletions (before Firebird 2.0) is
dropping the indexes first. I doubt that selecting db-keys first
then deleting records will help much, if at all.