I have a query that
Select Distinct VehicleId
From Vehicle
Where VehicleMileage between 0 and 15000.
I have an index on VehicleMileage. Is there another way to put an index on a between? The index is not being picked up. It does get picked up when I run
Select Distinct VehicleId
From Vehicle
Where VehicleMileage = 15000.
I just want to make sure that there is not a special index I should be using.
Thanks
