这个存储过程怎么优化?
ALTER PROC dbo.proc_MovePost @dt_begin datetime
AS
DECLARE @dt_end datetime,
@tbname sysname,
@s nvarchar(4000)
SELECT
@dt_end = DATEADD(Month, 1, @dt_begin),
@tbname = QUOTENAME('post_' + CONVERT(char(6), @dt_begin, 112))
select * into #temp_MovePost from post
where dateofpost>=@dt_begin and dateofpost<@dt_end
delete a from post a left join #temp_MovePost b on a.refindkey = b.refindkey where b.refindkey is not null
set @s = N'
delete a from #temp_MovePost a left join datascrape_master..' + @tbname+ N' b on a.refindkey = b.refindkey where b.refindkey is not null
insert into datascrape_master..' + @tbname+ N'(refindkey,firstextractiondate,latestextractiondate,threadid,subject,content,dateofpost,itemurl,poster,siteid,forumid,istopicpost)
select refindkey,firstextractiondate,latestextractiondate,threadid,subject,content,dateofpost,itemurl,poster,siteid,forumid,istopicpost from #temp_MovePost'
exec sp_executesql @s, N'@dt_begin datetime, @dt_end datetime', @dt_begin , @dt_end
GO