use adventureworks
go

select * from production.location
go

create index rateidx on production.location(locationid, costrate)
go

drop index rateidx on production.location

update statistics production.location
go

-- doesn't use index
select * from production.location with (index(rateidx))
go