--- In firebird-support@yahoogroups.com, "Puigsegur, Jordi"
<jordi.puigsegur@...> wrote:

>
> Thanks for your answers.
>
>
>
> The worst table has around 25 million records, of which 7-10 million
> need to be deleted. For what you say it seems that the best option is to
> drop the index, delete the records and recreate the index. I'll try
> that.
>
>
>
> Jordi.

Hola Jordi.

Jo també comprovaria que no hi hagi cap Trigger after/before delete,
que no necessitis i que puguis desactivar temporalment abans de fer el
borrat.

Salutacions.