下面这句SQL能不能优化一下,该如何解决

下面这句SQL能不能优化一下
delete   Forum_Vote   where   VoteID   in   (select   VoteID   from   Forum_Vote   where   Topic_ID= '[email protected]_ID+ '   and   VoteID   not   in( '[email protected]+ '))

------解决方案--------------------
delete Forum_Vote
where exists
(select 1 from Forum_Vote
where Topic_ID= '[email protected]_ID+ '
and VoteID not in( '[email protected]+ ') and VoteID=Forum_Vote.VoteID)
------解决方案--------------------
用關聯可能效率好些

Delete A From Forum_Vote A
Inner Join
(select VoteID from Forum_Vote where Topic_ID= '[email protected]_ID+ ' and VoteID not in( '[email protected]+ ')) B
On A.VoteID = B.VoteID