Subject Re: [firebird-support] Re: Best way to delete millions of rows
Author
---In firebird-support@yahoogroups.com, <jegaza@...> wrote :

>> Here you delete some records, but then count whole table.
>>Add same "where" condition as in "count" query
>
> I think the execution of select count is for garbage collection.

Sure

> If count of records that does not exists is executed, will be the garbage collection executed for the deleted records?

Exactly. No need to count not deleted records :)

Regards,
Vlad