Note that maps give you the opportunity to hand-optimize things like this if
your product's optimizer doesn't find a way to do it automatically.
let $A := a set of numbers
let $B := another set of numbers
let $map := fold-left($B, map{}, map:put(?, ?, true()))
return $A[empty($map(.))]
Michael Kay
Saxonica
[email protected]
+44 (0) 118 946 5893
On 28 Sep 2014, at 11:57, Ihe Onwuka <[email protected]> wrote:
> I have sequence A consisting of the numbers 0 to 4000000 and sequnce B
> consisting of about 100k random I numbers within the range of sequence A and
> I want the outer join where sequence B is "null".
>
> Should one expect bad performance in sequence B is not sorted and can one
> expect reasonable performance if it is?
>
> I am guessing that performance will vary by implemetation.
>
>
> _______________________________________________
> [email protected]
> http://x-query.com/mailman/listinfo/talk
_______________________________________________
[email protected]
http://x-query.com/mailman/listinfo/talk
