Not sure what either of these do. The docs: When using DIRECT, then the results from the query are directly applied in the target table without any intermediate step.
When using SORTED, b-tree pages are split at the insertion point. This can improve performance and reduce disk usage. What "intermediate step"? When would you want this "intermediate step"? When would you not use "direct"? What does "sorted" mean, here? Does this mean the rows must be in order of primary key? Or something else? -- 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.
