I'm doing a select like the following, with a user function B: SELECT B1 FROM (SELECT B(1, x) AS B1, B(2, x) AS B2 FROM system_range(0, 389)) WHERE (B2 IN (?,?,?...))
B is getting called about 130k times. There are about 680 items in the IN clause. So, it gets called a number of times equal to half the product of the system_range and the IN clause. I naively thought the subselect would call B 389*2 times, then table scan the results. What is it actually doing? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
