数据库查询0到10000和10000到20000哪个的效率更高

数据库查询0到10000和10000到20000哪个的效率更高

create table t5 ( item varchar(20))

insert t5 select '1-10000'

union all select '10000-20000'

union all select '20000-30000'

union all select '40000-50000'

----select

select * from table where score between 0 and 100

select * from table where score <=100

---insert

declare @score int

set @score=...

if @score<=100

begin

insert into table(...,score,...) values(...,@score,....)

end

---