|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.