|Subject||Re: [firebird-support] Re: Best way to delete millions of rows|
---In email@example.com, <jegaza@...> wrote :
>> Here you delete some records, but then count whole table.Sure
>>Add same "where" condition as in "count" query
> I think the execution of select count is for garbage collection.
> 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 :)