> 102 printed, 112 electronic :-)

:-)

>
>
> Theoretically, it could be indexed even now, if T2.C is declared as

NOT

> NULL. We could enable it as a short-term solution.
>

great !

> > and :
> > select * from t where c IN (select c from t2)
> > this will use index or not ?
>
> It will.
>

OK, because this is often used

Thanks
-Laco.