Yuri Marx · Dec 8, 2020

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 ( = e.role_id)
join    departments d on ( = 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
1 275
Discussion (3)2
Log in or sign up to continue

Yes, from system management portal System Explorer >> SQL you can enter a query and instead of executing it click "Show Plan".

Is it possible call from the sql command, or is accessible only from management portal?