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.)
_______________________________________________
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/[email protected]
** 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.
