On the INSERT statement in H2, what does `DIRECT` mean?

Asked Dec 23 '18 at 20:57

Active Dec 23 '18 at 20:57

Viewed 82 times

I noticed on the grammar documentation for INSERT in the H2 Database Engine, the optional word DIRECT. The documentation says:

When using DIRECT, then the results from the query are directly applied in the target table without any intermediate step.

When is data inserted not “directly applied”? What are these “intermediated steps”?

➥ What is the purpose of DIRECT?

➥ In what scenarios might one be motivated to use this feature?

asked Dec 23 '18 at 20:57

Basil Bourque

0 Answers0