下面这句SQL能不能优化一下

[IT_zen]

delete Forum_Vote where VoteID in (select VoteID from Forum_Vote where Topic_ID='+@Topic_ID+' and VoteID not in('+@VoteIDs+'))

[中国风]

用exists

[IT_zen]

delete Forum_Vote where VoteID where Topic_ID='+@Topic_ID+' and not in('+VoteIDs+')

[中国风]

delete Forum_Vote
where exists
(select 1 from Forum_Vote
where Topic_ID='+@Topic_ID+'
and VoteID not in('+@VoteIDs+') and VoteID=Forum_Vote.VoteID)

[IT_zen]

delete Forum_Vote where Topic_ID='+@Topic_ID+' and VoteID not in('+VoteIDs+')

[paoluo]

用關聯可能效率好些

Delete A From Forum_Vote A
Inner Join
(select VoteID from Forum_Vote where Topic_ID='+@Topic_ID+' and VoteID not in('+@VoteIDs+')) B
On A.VoteID = B.VoteID

[IT_zen]

请问激情,你写的和这个语句哪个效率更高,执行更快,
delete Forum_Vote where Topic_ID='+@Topic_ID+' and VoteID not in('+VoteIDs+')

[paoluo]

的確，好象可以直接這麼寫

Delete Forum_Vote where Topic_ID='+@Topic_ID+' and VoteID not in('+@VoteIDs+')

[IT_zen]

谢谢