¿Es posible ver el plan de ejecución de una sentencia SQL en IRIS? Como esto:
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');Que devuelve esto: ![](https://cdn.app.compendium.com/uploads/user/e7c690e8-6ff9-102a-ac6d-e4aebca50425/6e9e0d66-08a0-4da0-a2ca-3598bcc28d7a/Image/01b0298944aea4ba74af1fd1b833317e/plan_z_0.jpg)