SQL Query execution plan
Is it possible see the execution plan of a SQL sentence in IRIS?
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