Noel,
Thanks for the suggestion. I opted for a JOIN for the time-being. I am a
little hesitant to upgrade h2 versions, because we are using it in
production. When I have time, I hope to locally test the newest stable h2
to see if the IN Select is now optimized to not repeat a sub-query.
Bes
Convert it to a join.
Or pick a newer version, but stick with the PAGE_STORE engine, I'm pretty
much we've made lots of plannerimprovements since 1.3.176
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop re
Hi,
I put in a logger via a user defined function, and it seems to in fact
re-execute the IN sub-query for every matching outer row. Am I
interpreting this correctly? Any work around?
-Adam
On Sunday, September 18, 2016 at 8:25:20 PM UTC-4, Adam McMahon wrote:
>
> Hi,
>
> When a SELECT is us