I usually create an index for each individual field involved in my primary query for a table. Seems to work faster but I have no scientific evidence to prove it. Seems like I read somewhere that it's best for Rushmore to kick in. But I might have dreamed it all so buyer beware.
I'm prepared to be corrected.
Paul
Sent from my iPhone
On 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]