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.

Syntax

Following is the generic syntax of the EXPLAIN command.

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

Example

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

The above command produces the following output −

explain_output

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

H2 Database Topics