jxd7_xt_organise 组织机构表;
jxd7_xt_user 人员信息表原sql语句:
select distinct t4.organiseid, t4.organiselevel
from jxd7_xt_organise t4,
(select distinct t3.organiselevel
from jxd7_xt_user t2, jxd7_xt_organise t3
where t2.deptid = t3.organiseid
and t2.username like '%%') t5
where t5.organiselevel like t4.organiselevel || '%'查询目的:根据用户姓名模糊查询,把含有符合条件的用户所在组织机构及其直系父节点查询出来,便于形成组织机构树。以上语句执行用时12.5s。求助大家优化以下!!谢谢!
jxd7_xt_user 人员信息表原sql语句:
select distinct t4.organiseid, t4.organiselevel
from jxd7_xt_organise t4,
(select distinct t3.organiselevel
from jxd7_xt_user t2, jxd7_xt_organise t3
where t2.deptid = t3.organiseid
and t2.username like '%%') t5
where t5.organiselevel like t4.organiselevel || '%'查询目的:根据用户姓名模糊查询,把含有符合条件的用户所在组织机构及其直系父节点查询出来,便于形成组织机构树。以上语句执行用时12.5s。求助大家优化以下!!谢谢!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货