Subject Re: [firebird-support] Re: perf WHERE IN (SUBQUERY)
Author Dmitry Yemanov
"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 :-)