The "Explain Plan" panel is meant to show how the engine intends to execute the statement under the cursor: which tables are read in which order, which of them are read from the platform and which from the [[Invantive UniversalSQL/Invantive Data Cache/Invantive Data Cache|Invantive Data Cache]], and where the rows are joined, sorted and grouped. The panel belongs to the document being edited.
In release 27.0 the panel stays empty: the plan is not requested for the statement in the editor. The plan of a statement is available in other ways:
- the [[Invantive Query Tool/Trace|Trace]] panel names each step of the execution as the engine takes it, with the rows and the time it cost;
- the statistics of the last execution are in the [[Invantive Query Tool/History|History]] panel: the time spent on the platform, on the processor and waiting, the number of calls and the number of partitions addressed;
- on a platform which offers a plan of its own the statement for it - `explain plan` on Oracle, `set showplan_all` on Microsoft SQL Server - is executed as a native statement, and its answer appears in the "Results" panel like that of any other statement.