Hi,

I have a query related to garbage collection in firebird.As I know
there are two ways garbage collection mechanisms
1. Explicit: which a user calls by gfix or gbak.
2. Implicit: which is performed by firebird itself. From what I have
learnt on the Internet this happens in many ways
[a] when executing a select query it encounters on a deleted row in
the database it performs garbage collection on it
[b] after the expiry of the sweep interval it runs a separate
garbage collection thread

Is my understanding about the implicit garbage collection correct?
Does it happen in one of the two ways or both ways? I would also ask
how is the sweep interval calculated.

Thanks in advance

Regards
Deepak