Hello. There is nothing to do with temporary results in H2. If you have large queries and they may return parts of results early, use `LAZY_QUERY_EXECUTION=TRUE`. If some query doesn't support lazy execution, there is nothing to do with it in H2 itself. With `LAZY_QUERY_EXECUTION=TRUE` H2 uses LocalResult if and only if rows need a post-processing, such as sorting, distinct filtration, or OFFSET / FETCH filtration and these operations can't be performed early, for example, because there are no compatible indexes or some previous step needs a complete set of rows. In all these cases rows passed to LocalResult are not the same rows as will be returned by ResultSet.
-- 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/b45aa672-fccb-4e03-803f-8a79201b9af0n%40googlegroups.com.
