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 100,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/53344bf1-0da2-4b17-99ad-d72073e192d8%40googlegroups.com.
