工作需要写一个查询:
最开始写了最原始的嵌套查询:
select * from realservice where realservname in (select realservname from groupmember where groupname in (select groupname from v_group where vname in (select vname from vservice where vip = '10.181.65.185')));
发现很慢,查了一下用时4min 22.74sec。
然后考虑如何优化,自然想到了连接,然后优化后代码如下:
select * from realservice as a join groupmember as b where a.realservname=b.realservname and b.groupname in (select a.groupname from v_group as a join vservice as b where a.vnam