H2 Database Explain - H2 Database

What isH2 Database Explain?

EXPLAIN command displays the execution plan for a statement. When we execute a statement using EXPLAIN ANALYZE command, the query plan will include the actual row scan count for each table.


Following is the generic syntax of the EXPLAIN command.

Along with this syntax we can use select, insert, delete, and merge.


This example explains the query plan details of the customer with ID 1.

The above command produces the following output −


All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

H2 Database Topics