Anthony, I think 5.2.1 Explain Syntax in the manual covers what you are
asking about. PB
----
----- Original Message -----
From: Anthony Ward
To: [EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 2:26 PM
Subject: good or bad?
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
