Hi,

> I would probably do this as
> Select * from GenLedger where Tranref in (select Tranref from GenLedger

when

> Actn = 'C') Especially if Actn does not have an index on it.
>
> What do the two different Q's return as a plan?
>
> JAC

Isn't that the same as :

Select * from GenLedger where Actn = 'C'

but without the very slow IN statement

Regards,
Arno