select a.* from all_info_view a,hyoa_employee b where b.empCode='61' and ((a.dateandtime BETWEEN convert(datetime,'2006-11-26 21:26:52 ') and convert(datetime,'2006-11-27 21:26:52 '))) and ((b.share_name like '%,'+a.userName+',%' )or(b.share_name like '%,'+a.to_username+',%' )) order by dateandtime desc
sqlserver达到100%cpu,要怎么优化呢
b.share_name 是text类型
sqlserver达到100%cpu,要怎么优化呢
b.share_name 是text类型
from all_info_view a,hyoa_employee b
where b.empCode='61' and
(a.dateandtime BETWEEN '2006-11-26 21:26:52 ' and '2006-11-27 21:26:52 ')
and ((b.share_name like '%,'+a.userName+',%' )or(b.share_name like '%,'+a.to_username+',%' ))
order by dateandtime desc
--楼主的联接出现的交叉联
all_info_view是个视图