Hi,
going to back to the thread of best SQL statment i did:
this
EXPLAIN
SELECT *
FROM `zip`
WHERE longitude
BETWEEN - 98.315 AND - 94.662 AND latitude
BETWEEN 31.696 AND 34.587 AND 3963 * acos( cos( latitude ) * cos( 33.1414 ) + sin(
latitude ) * sin( 33.1414 ) * cos( - 96.5883 - longitude ) ) < 1000
Now I have created one index containing longitude and latitude in that order the
index name is 'longlat'. and the result of the explain is this:
**table name is zip and i have about 42 192 rows **
table type possible_keys key key_len ref rows Extra
zip range longlat longlat 8 NULL 4323 where used
What do you think? I can't really read that eventough I tried to go Mysql.com . For my
conclusion it is time to buy a book about MySQL!!
any help is appreciated.
Anthony
