大数据量下的SQL分页查询性能优化策略

declare @nGotoPage int, @nPageSize int;
set @nGotoPage = 1;
set @nPageSize = 100000;
with T_Data(RowID, ID, CID, DisplayName, WriteDate, Body)
as
(
    select Row_Number() over (order by ID) as RowID, 
            ID, CID, DisplayName, WriteDate, Body
     from Test
     where CID = 1
),
T_DataCount(nRecordCount)
as
(
    select count(*) from T_Data
)
select _RecordCount = t2.nRecordCount,
        _PageCount = Ceiling(t2.nRecordCount * 1.0 / @nPageSize),
        t1.* from T_Data as t1, T_DataCount as t2 
where RowID > ((@nGotoPage - 1) * @nPageSize) and RowID <= (@nGotoPage * @nPageSize);