Subject | Re: [firebird-support] Re: Best way to delete millions of rows |
---|---|
Author | |
Post date | 2016-10-31T20:54Z |
---In firebird-support@yahoogroups.com, <jegaza@...> wrote :
Regards,
Vlad
>> 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 :)
Regards,
Vlad