> No, those indexes were intentional. If you read the section of the manual > on optimizing queries, you will encounter a page that mentions what are > known as "covering indexes". The advantage to a covering index is that if > your data is numeric and in the index,
Except that the zip code field is not (and should not be) numeric, so the qualification test fails. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]