|Subject||Re: SQL performance SS FB 3.0.1 vs SC FB 2.5.2|
09.08.2016 04:56, trskopo@... wrote:
>Which exactly v3.0.1 build number?
> Just found that on a particular case, SS FB 3.0.1 is about 4x slower
> than SC FB 2.5.2.
> Here is the query :Please show the detailed (aka explained) plan from v3.
> select a.id,b.nm from tbl1 a, tbl2 b
> where a.id = b.id
> and a.id in (select c.id from tbl3 c)