Dmitry Yemanov wrote:

> He said he tried the join I suggested him and no index has been used for
> SUBARTIS. This sounds weird, hence I'm asking for a plan...
>
>
> Dmitry
>
>

Dmitry,

Well, maybe I am wrong, but from what I read (or better, from what I
understood) he always is comparing the "IN <constant>" vs "IN
<subquery>" as he tells about plans and first/second query.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br