EXPLAIN Statement

The EXPLAIN statement supported by UnityJDBC has the following syntax:

EXPLAIN <query>

The EXPLAIN statement provides an explanation of the how UnityJDBC will execute a given query include the translated queries to be executed on each source, the operations performed by UnityJDBC, and the expected cost of each query operation. Using EXPLAIN is a great way to determine the performance of queries and improve their execution speed.