On 24/01/07, Ann W. Harrison <aharrison@...> wrote:

> 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?
>
> When you backup the database, unless you use the -g switch.

so If I never backup either, the deleted stubs never get removed? (all
very short transactions so the OIT gap never gets big enough to cause
a sweep).

looks like I need to make a sweep occur in order to avoid the database
growing and growing.