VFP9SP2 free table
I've got a table with this structure:
city c(30)
state c(2)
radius i
distance i
My query is looking for city, state, and radius, to get back those whose
distance is <= InputParameter.
select *
from MyTable
where city = m.tcCity and state = m.tcState and radius <= m.tiRadius
Not sure if I should
index on city tag city
index on state tag state
index on radius tag radius
or
index on city + state + padl(allt(str(radius)),6,'0') tag MyTag
???
I know I can use SYS(3054) to get my answer but I'm getting ready to be
away from the office for a bit and was hoping someone knew the obvious
answer. Otherwise I'll run my testing later tonight.
(At the very least, hopefully somebody learned about SYS(3054,x,y)
today.)