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