Re: One example of a slow query.

by Ed Prochak <edprochak@[EMAIL PROTECTED] > Jun 25, 2008 at 05:09 AM

On Jun 25, 4:13 am, David Segall <da...@[EMAIL PROTECTED]
> wrote:
> "David Cressey" <cresse...@[EMAIL PROTECTED]
> wrote:
> > Because
> >there was an index with a compound index key,  namely country, state,
and
> >city.
>
> Why would you do that instead of indexing the fields separately?

Better is one index defines as city, state, country.
Put the most discriminating element first. then partial searches on
that index still work.
  Ed

9 Posts in Topic:

One example of a slow query.

"David Cressey"

2008-06-24 18:18:08

Re: One example of a slow query.

David Segall <david@[E

2008-06-25 09:13:38

Re: One example of a slow query.

"Roy Hann" <

2008-06-25 11:12:55

Re: One example of a slow query.

"Arved Sandstrom&quo