I wonder how many rows do you expect to come back. Even if you have 30 year of history in your table (an given a financial nature of your data it can't be significantly longer than that), it would give us ~ 10,000 dates, which would yield 100 rows per date on average. Under such assumption join result might have 10,000,000,000 rows. At least it has to be executed in a lazy fashion, but most likely you need some limiting conditions.
-- 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 view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/99d5ca04-5f9a-4445-8b11-a26afba755e7%40googlegroups.com.
