Use an index to identify differences for it to work best.
I would do an index on Citi alone. Let the State just be a simple scan as a speed test. Then add an index on State but I do not think you are going to gain any leverage from it.
Indexes find what you want quickly. < is a comparison and not good for an index Seek, only an index scan.
On Fri, Nov 3, 2017 at 4:09 PM, <mbsoftwaresolutions@mbsoftwaresolutions.com
wrote:
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.)
[excessive quoting removed by server]