给member&shiji表的"会员名"字段建索引insert into _Status_EmailSend(MemberId,StatusId) select top 1 t.序号,100 from member t where exists(select 1 from _MemberFromMenhu where EnterpriseBelongtoMenhuId=1 and MemberId=t.序号) and not exists(select 1 from _Status_EmailSend where StatusId=100 and MemberId=t.序号) and not exists(select 1 from shiji where 会员名=t.会员名)
select
top 1 t.序号,100
from
member t
where
exists(select 1 from _MemberFromMenhu where EnterpriseBelongtoMenhuId=1 and MemberId=t.序号)
and
not exists(select 1 from _Status_EmailSend where StatusId=100 and MemberId=t.序号)
and
not exists(select 1 from shiji where 会员名=t.会员名)
同時exists比not in 在執行效率上要快些。