sqlserver-全文索引多表查询效率问题

多表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')

 

http://support.microsoft.com/kb/2264562/zh-cn