On 24/01/07, Markus Ostenried <macnoz@...> 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.

what I meant was that there is no table scan, so the deleted stub is
never touched, as far as I can work out.