From: Hank Date: April 19 2005 5:33pm Subject: Re: zip code search within x miles List-Archive: http://lists.mysql.com/mysql/182855 Message-Id: <1990a96b05041910337d5f19a1@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable On 4/19/05, Keith Ivey wrote: > Also, the index on zip_code, latitude, and longitude doesn't > make sense. =20 Yeah - I didn't even notice the indexes in the table def (I used my own existing zip code table). That table def and query were obviously created by someone pretty green with SQL. -Hank