On Sat, Nov 4, 2017 at 5:09 AM, <[email protected]> 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! _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAGv=MJCStXw1aCd4a4at6FzNX73be=suqegrsbwtkdbnox3...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
