use tempdb
go

set nocount on 
set statistics io off

--drop table force_seek_table
create table force_seek_table
(
	col1 int identity not null,
	col2 tinyint not null
);
go

begin tran;
declare @i int;
set @i = 1;
while (@i <= 1000000)
begin
	if (@i <=100000)
		insert into force_seek_table (col2) values (10);
	if (@i > 100000 and @i <= 1000000)
		insert into force_seek_table (col2) values (90);
	set @i = @i + 1;
end
commit;
go

create nonclustered index force_seek_table on force_seek_table (col2);
go

select * from force_seek_table
where col2 = 10;

select * from force_seek_table with (forceseek)
where col2 = 10;