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 Pam Ozer
