oracle语句查询时间过长，请帮忙优化。谢谢！

with t as (
select o.menuid
from t_sys_operation o inner join t_sys_role_operation ro on o.sysname = ro.sysname and o.powerid = ro.powerid and o.action = ro.action
inner join t_sys_ro