drop table if exists stat_test;
create table stat_test (a int, b int);

insert into stat_test (a, b)
select 1, ABS(CHECKSUM(NEWID()) % 6) + 1 from string_split(replicate(cast(';' as varchar(max)), 49999), ';')

insert into stat_test(a, b) values (2, 100)


create index ix on stat_test (a, b)
create index iy on stat_test (b, a)

set statistics xml, io, time on
go
select count_big(1) from stat_test where a = 1 option (recompile)
go
select count_big(1) from stat_test with(index=0) where a = 1 option (recompile)
go
set statistics xml, io, time off
go

update statistics stat_test(ix) with pagecount=10000000
go


set statistics xml, io, time on
go
select count_big(1) from stat_test where a = 1 option (recompile)
go
select count_big(1) from stat_test with(index=0) where a = 1 option (recompile)
go
set statistics xml, io, time off
go

drop table if exists stat_test