SQL Server 2008查询计划警告“No Join Predicate”，查询需要很长时间

Here is my SQL

这是我的SQL

select DISTINCT d.* from Device d, Company c1 
WHERE 

EXISTS ( select * from (SELECT * FROM [dbo].[Split] ('HENNEPIN COUNTY MN', ',')) as s     
        WHERE c1.CompanyName like '%' + s.items + '%' AND d.CustomerID  c1.CompanyID)
OR  
EXISTS ( select * from (SELECT * FROM [dbo].[Split] ('HENNEPIN COUNTY MN', ',')) as s     
        WHERE d.CustomerName like '%' + s.items + '%')
select DISTINCT d.*