Markus Ostenried wrote:

> On 1/24/07, Nick Upson <nick.upson@...> wrote:
>> select count(*) touches all records but if my only access into the
>> table is via an index and I never sweep, when does the deleted stub
>> get removed?
>
> AFAIR an index only access is not possible because there is no
> transaction information stored in the indexes.

That's true, but not very relevant in this case. Indexed access
to one record won't cause Firebird to look for other deleted
records. Reading record A through an index leave record B
untouched.

Regards,


Ann