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.