多表Contains查询最初用OR,效率很低,查了资料改用union ,每个contains为一个子查询
select * from pdt where Contains(name,'a')
union
select * from pdt inner join Company as c where Contains(c.name,'c')
多表Contains查询最初用OR,效率很低,查了资料改用union ,每个contains为一个子查询
select * from pdt where Contains(name,'a')
union
select * from pdt inner join Company as c where Contains(c.name,'c')
转载于:https://www.cnblogs.com/sadsheep/archive/2012/07/10/2584375.html