4 Nov
2017
4 Nov
'17
12:42 p.m.
On Sat, Nov 4, 2017 at 5:09 AM, 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.
For Rushmore optimization, one index per field. Then use SQL to query or sort. Do NOT build compound indexes unless you have special needs.
--
.~. Might, Courage, Vision. SINCERITY!
/ v \ 64-bit Fedora 25 Server Spin
/( _ )\ http://sites.google.com/site/changmw
^ ^ May the Force and farces be with you!