海量数据库的查询优化及分页算法方案

CREATE TABLE [dbo].[TGongwen] (    --TGongwen是红头文件表名
   [Gid] [int] IDENTITY (1, 1) NOT NULL ,
--本表的id号，也是主键
   [title] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL ,  
--红头文件的标题
   [fariqi] [datetime] NULL ,
--发布日期
   [neibuYonghu] [varchar] (70) COLLATE Chinese_PRC_CI_AS NULL ,
--发布用户
   [reader] [varchar] (900) COLLATE Chinese_PRC_CI_AS NULL ,
--需要浏览的用户。每个用户中间用分隔符“,”分开
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

declare @i int
set @i=1
while @i<=250000
begin
    insert into Tgongwen(fariqi,neibuyonghu,reader,title) values
('2004-2-5','通信科','通信科,办公室,王局长,刘局长,张局长,admin,
刑侦支队,特勤支队,交巡警支队,经侦支队,户政科,治安支队,外事科',
'这是最先的25万条记录')
    set @i=@i+1
end
GO

declare @i int
set @i=1
while @i<=250000
begin
    insert into Tgongwen(fariqi,neibuyonghu,reader,title) values
('2004-9-16','办公室','办公室,通信科,王局长,刘局长,张局长,admin,
刑侦支队,特勤支队,交巡警支队,经侦支队,户政科,外事科',
'这是中间的25万条记录')
    set @i=@i+1
end
GO

declare @h int
set @h=1
while @h<=100
begin
declare @i int
set @i=2002
while @i<=2003
begin
declare @j int
        set @j=0
        while @j<50
            begin
declare @k int
            set @k=0
            while @k<50
            begin
    insert into Tgongwen(fariqi,neibuyonghu,reader,title) values
(cast(@i as varchar(4))+'-8-15 3:'+cast(@j as varchar(2))+':
'+cast(@j as varchar(2)),'通信科','办公室,通信科,王局长,刘局长,
张局长,admin,刑侦支队,特勤支队,交巡警支队,经侦支队,户政科,外事科',
'这是最后的50万条记录')

            set @k=@k+1
            end
set @j=@j+1
        end
set @i=@i+1
end
set @h=@h+1
end
GO

declare @i int
set @i=1
while @i<=9000000
begin
    insert into Tgongwen(fariqi,neibuyonghu,reader,title) values
('2004-5-5','通信科','通信科,办公室,王局长,刘局长,张局长,admin,
刑侦支队,特勤支队,交巡警支队,经侦支队,户政科,治安支队,外事科',
'这是最后添加的900万条记录')
    set @i=@i+1000000
end
GO