SQL Query execution plan
Is it possible see the execution plan of a SQL sentence in IRIS?
Like this:
explain plan for
select e.ename,r.rname
from employees e
join roles r on (r.id = e.role_id)
join departments d on (d.id = e.dept_id)
where e.staffno <= 10
and d.dname in ('Department Name 1','Department Name 2');That returns this:

Product version: IRIS 2020.4
Discussion (3)2
Comments
Yes, from system management portal System Explorer >> SQL you can enter a query and instead of executing it click "Show Plan".
.png)
Is it possible call from the sql command, or is accessible only from management portal?
EXPLAIN SQL command is supported in InterSystems IRIS.