"legrand_legrand_63" <grand.brun.63@...> wrote:

>
> In fact I'm posting that question because this IN statement was
> originaly done in Oracle without any performance problem, Oracle First
> read (once) the subquery on B and reads A using A_ID index ...

Oracle can execute the IN predicate in three different ways, depending on
the available statistics and some conditions. But we're not Oracle yet :-)


Dmitry