I think writing the query in such a way
that allows it to be parallelised is likely going to result in some
quite good performance improvements. i.e:
Agreed, though if the query author needs to do that here we’ve violated the spirit of the declarative SQL language. At first blush nothing about the original query seems like it should be preventing parallelism. Each worker builds its own distinct array then the final concatenation is made distinct.
David J.
