SQL Statements

EXPLAIN

sql-statement ::= EXPLAIN sql-statement

The EXPLAIN command modifier is a non-standard extension. The idea comes from a similar command found in PostgreSQL, but the operation is completely different.

If the EXPLAIN keyword appears before any other eSQL SQL command then instead of actually executing the command, the eSQL library will report back the sequence of virtual machine instructions it would have used to execute the command had the EXPLAIN keyword not been present.