| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Hank | Date: | April 19 2005 6:55pm |
| Subject: | Re: zip code search within x miles | ||
| View as plain text | |||
> 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.
