Sqlserver填充因子测试

CREATE TABLE [dbo].[test](
    [id] [int] IDENTITY(1,1) NOT NULL primary key,
    [aa] [int] NULL,
    [bb] [int] NULL)
    
CREATE NONCLUSTERED INDEX [aa] ON [dbo].[test] 
(
    [aa] ASC
    )

CREATE NONCLUSTERED INDEX [bb] ON [dbo].[test] 
(
    [bb] ASC
)WITH (FILLFACTOR = 50)

declare @aa int
declare @bb int
set @aa=50
set @bb=50
while @aa<1000000
begin
insert into [test](aa,bb)
select @aa,@bb
set @aa=@aa+50
end

CREATE NONCLUSTERED INDEX [bb] ON [dbo].[test] 
(
    [bb] ASC
)WITH (FILLFACTOR = 50,DROP_EXISTING=ON)

declare @aa int
declare @bb int
set @aa=1000001
set @bb=1000001
while @aa<10000000
begin
insert into [test](aa,bb)
select @aa,@bb
set @aa=@aa+500
end