On 17/06/2020 19:45, liviuslivius wrote: > Are you sure? > It shoul use 2 as it i equal to > (registro_pri_roest = 1 and registro_sec_roest = 1) or > (registro_pri_roest = 1 and registro_sec_roest = 2) >
With this the two segments is used in the plan. But then I see what Dmitry said about ConditionalStream being not created if there is an additional "or (registro_pri_roest = 1 and value is null)". Adriano Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel