临时表性能问题

我的存储过程分页部分，利用了三次相同条件的查询，获得最终的数据
代码如下：

SQL code

DECLARE @TotalPage int
SELECT @TotalPage = Count (Identifier) FROM View_BbsInfo WHERE
( @Identifier IS NULL OR Identifier = @Identifier ) AND
( @IsTop IS NULL OR IsTop = @IsTop ) AND
( @IsPlacard IS NULL OR IsPlacard = @IsPlacard )
IF ( @TotalPage % @PageSize = 0 )
BEGIN
SET @TotalPage = @TotalPage / @PageSize
END
ELSE
BEGIN
SET @TotalPage = Round ( @TotalPage / @PageSize , 0 ) + 1
END
SELECT TOP ( @PageSize ) Identifier,IsTop,IsPlacard, @TotalPage as totalPage FROM View_BbsInfo WHERE
Identifier NOT IN ( SELECT Top ( @PageSize * ( @CurrentPage - 1 ))Identifier FROM View_BbsInfo WHERE
( @Identifier IS NULL OR Identifier = @Identifier ) AND
( @IsTop IS NULL OR IsTop = @IsTop ) AND
( @IsPlacard IS NULL OR IsPlacard = @IsPlacard ))
AND
( @Identifier IS NULL OR Identifier = @Identifier ) AND
( @IsTop IS NULL OR IsTop = @IsTop ) AND
( @IsPlacard IS NULL OR IsPlacard = @IsPlacard )

优化后，我首先利用临时表将条件查询的所有结果存储起来，然后再分页查询该临时表

代码如下：

SQL code

-- 查询结果到临时表
SELECT TOP ( @PageSize ) Identifier,IsTop,IsPlacard INTO #tempTable FROM View_BbsInfo WHERE
( @Identifier IS NULL OR Identifier = @Identifier ) AND
( @IsTop IS NULL OR IsTop = @IsTop ) AND
( @IsPlacard IS NULL OR IsPlacard = @IsPlacard )

DECLARE @TotalPage int
SELECT @TotalPage = Count (Identifier) FROM #tempTable
IF ( @TotalPage % @PageSize = 0 )
BEGIN
SET @TotalPage = @TotalPage / @PageSize
END
ELSE
BEGIN
SET @TotalPage = Round ( @TotalPage / @PageSize , 0 ) + 1
END
SELECT TOP ( @PageSize ) Identifier,IsTop,IsPlacard, @TotalPage as totalPage FROM #tempTable WHERE
Identifier NOT IN ( SELECT Top ( @PageSize * ( @CurrentPage - 1 ))Identifier FROM #tempTable

问题来了，没进行测试，不知道哪种的性能更好些？

尽管减少了三次查询的过程，但是建立临时表的过程依然需要插入、查询操作，感觉性能的确不好确定
希望各位帮忙解释一下哪种比较好？

转载于:https://www.cnblogs.com/mikel/archive/2008/10/23/1317394.html