Sample Header Ad - 728x90

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

3 votes
0 answers
83 views
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 by Basil Bourque (11188 rep)
Dec 23, 2018, 08:57 PM